{"id":3309,"date":"2026-05-04T18:13:28","date_gmt":"2026-05-04T10:13:28","guid":{"rendered":"http:\/\/i-services.info\/cspclm\/?p=3309"},"modified":"2026-05-04T18:24:36","modified_gmt":"2026-05-04T10:24:36","slug":"excel-fabric-power-bi-copilot-%e5%84%80%e8%a1%a8%e6%9d%bf","status":"publish","type":"post","link":"http:\/\/i-services.info\/cspclm\/?p=3309","title":{"rendered":"Excel &rarr; Fabric &rarr; Power BI Copilot \u5100\u8868\u677f"},"content":{"rendered":"<h5>\u5b8c\u6574 Step-by-Step \u6559\u5b78\uff1aExcel \u2192 Fabric \u2192 Power BI Copilot \u5100\u8868\u677f<\/h5>\n<p><a href=\"http:\/\/i-services.info\/cspclm\/wp-content\/uploads\/2026\/05\/image.png\"><img loading=\"lazy\" title=\"image\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; margin: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"image\" src=\"http:\/\/i-services.info\/cspclm\/wp-content\/uploads\/2026\/05\/image_thumb.png\" width=\"365\" height=\"662\"><\/a><\/p>\n<p><a href=\"https:\/\/learn.microsoft.com\/zh-tw\/fabric\/fundamentals\/fabric-trial\">Fabric \u8a66\u7528\u5bb9\u91cf &#8211; Microsoft Fabric | Microsoft Learn<\/a> (\u514d\u8cbb\u8a66\u7528 Microsoft Fabric)<\/p>\n<p><a href=\"https:\/\/learn.microsoft.com\/zh-tw\/fabric\/enterprise\/fabric-features\">Microsoft Fabric \u529f\u80fd\u4f9d SKU \u5206\u985e &#8211; Microsoft Fabric | Microsoft Learn<\/a><\/p>\n<p><a href=\"https:\/\/learn.microsoft.com\/zh-tw\/fabric\/fundamentals\/fabric-trial#end-a-fabric-trial\">Fabric \u8a66\u7528\u5bb9\u91cf &#8211; Microsoft Fabric | Microsoft Learn<\/a> (\u53d6\u6d88 Fabric \u5e73\u53f0\u8a66\u7528\u7248)<\/p>\n<p><a href=\"https:\/\/learn.microsoft.com\/zh-tw\/fabric\/enterprise\/buy-subscription\">\u8cfc\u8cb7 Microsoft Fabric \u8a02\u7528\u5e33\u6236 &#8211; Microsoft Fabric | Microsoft Learn<\/a><\/p>\n<p><a href=\"http:\/\/i-services.info\/cspclm\/wp-content\/uploads\/2026\/05\/image-1.png\"><img loading=\"lazy\" title=\"image\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; margin: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"image\" src=\"http:\/\/i-services.info\/cspclm\/wp-content\/uploads\/2026\/05\/image_thumb-1.png\" width=\"720\" height=\"606\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<hr>\n<h6> STEP 1\uff1a\u4e0a\u50b3 Excel \u5230 Microsoft Fabric<\/h6>\n<ol>\n<li>\u958b\u555f <a href=\"https:\/\/app.fabric.microsoft.com\">https:\/\/app.fabric.microsoft.com<\/a>\uff0c\u767b\u5165\u4f60\u7684\u5e33\u865f\n<li>\u5de6\u5074\u9078 <strong>My Workspace<\/strong>\uff08\u6216\u4f60\u7684\u76ee\u6a19 Workspace\uff09\n<li>\u9ede\u4e0a\u65b9 <strong>\u300c+ New\u300d\u2192\u300cUpload files\u300d<\/strong>\n<li>\u9078\u64c7\u525b\u4e0b\u8f09\u7684 <code>CSP\u8a02\u55ae\u8cc7\u6599_cleaned.xlsx<\/code> \u4e0a\u50b3\n<li>\u4e0a\u50b3\u5b8c\u6210\u5f8c\uff0c\u5728 Workspace \u88e1\u6703\u770b\u5230\u8a72\u6a94\u6848\uff0c\u9ede\u9078\u5b83 <\/li>\n<\/ol>\n<hr>\n<h6> STEP 2\uff1a\u5c07 Excel \u8f49\u63db\u70ba Lakehouse \u8cc7\u6599\u8868\uff08\u8b93 Copilot \u53ef\u8b80\uff09<\/h6>\n<ol>\n<li>\u5728 Fabric \u5de6\u5074\u9078 <strong>\u300cData Engineering\u300d<\/strong>\n<li>\u5efa\u7acb\u6216\u9078\u64c7\u4e00\u500b <strong>Lakehouse<\/strong>\n<li>\u5728 Lakehouse \u9801\u9762\uff0c\u9ede <strong>\u300cGet data\u300d\u2192\u300cUpload files\u300d<\/strong>\uff0c\u518d\u6b21\u4e0a\u50b3 cleaned.xlsx\n<li>\u4e0a\u50b3\u5f8c\u9ede\u9078\u8a72 Excel \u6a94\uff0c\u9078\u64c7 <strong>\u300cLoad to Tables\u300d<\/strong>\n<li>\u78ba\u8a8d\u6b04\u4f4d\u578b\u5225\uff0c\u7279\u5225\u78ba\u4fdd\uff1a\n<ul>\n<li><code>\u6578\u91cf<\/code>\u3001<code>\u5c55\u7881COST\u55ae\u50f9\u672a\u7a05<\/code>\u3001<code>\u5c55\u7881COST\u672a\u7a05\u5c0f\u8a08<\/code>\u3001<code>\u6210\u4ea4\u55ae\u50f9\u672a\u7a05<\/code>\u3001<code>\u6210\u4ea4\u50f9\u672a\u7a05\u5c0f\u8a08<\/code> \u2192 <strong>\u6574\u6578\/\u5341\u9032\u4f4d\u6578<\/strong>\n<li><code>\u958b\u55ae\u65e5<\/code>\u3001<code>\u8a02\u55ae\u4e0b\u55ae\u65e5<\/code>\u3001<code>\u8a02\u95b1\u5230\u671f\u65e5<\/code> \u2192 <strong>\u65e5\u671f\/\u6642\u9593<\/strong><\/li>\n<\/ul>\n<li>\u6309 <strong>\u300cLoad\u300d<\/strong> \u5b8c\u6210\u5efa\u8868 <\/li>\n<\/ol>\n<hr>\n<h6> STEP 3\uff1a\u5efa\u7acb Power BI Semantic Model<\/h6>\n<ol>\n<li>\u56de\u5230 Lakehouse \u9996\u9801\uff0c\u9ede\u53f3\u4e0a\u89d2 <strong>\u300cNew semantic model\u300d<\/strong>\n<li>\u9078\u525b\u525b\u5efa\u597d\u7684\u8cc7\u6599\u8868\uff08<code>CSP\u8a02\u55ae\u8cc7\u6599_cleaned<\/code>\uff09\uff0c\u52fe\u9078\u5f8c <strong>\u300cConfirm\u300d<\/strong>\n<li>\u7cfb\u7d71\u6703\u81ea\u52d5\u5efa\u7acb Semantic Model\uff0c\u7a0d\u5f85\u5e7e\u79d2 <\/li>\n<\/ol>\n<hr>\n<h6> STEP 4\uff1a\u958b\u555f Power BI \u5831\u8868\u4e26\u555f\u7528 Copilot<\/h6>\n<ol>\n<li>\u5728 Semantic Model \u9801\u9762\uff0c\u9ede <strong>\u300cCreate report\u300d\u2192\u300cStart with a blank canvas\u300d<\/strong>\n<li>\u5831\u8868\u958b\u555f\u5f8c\uff0c\u53f3\u5074\u9762\u677f\u627e\u5230 <strong>\u300cCopilot\u300d<\/strong> \u5716\u793a\uff08\u9b54\u6cd5\u68d2 \u2728\uff09\u4e26\u9ede\u958b\n<ul>\n<li>\u82e5\u6c92\u770b\u5230\uff1a\u9ede\u4e0a\u65b9 <strong>\u300cView\u300d\u2192\u300cCopilot\u300d<\/strong><\/li>\n<\/ul>\n<li>Copilot \u5074\u908a\u6b04\u6703\u51fa\u73fe\u5c0d\u8a71\u6846\uff0c\u5373\u53ef\u958b\u59cb\u7528\u81ea\u7136\u8a9e\u8a00\u751f\u6210\u8996\u89ba\u5716\u8868 <\/li>\n<\/ol>\n<hr>\n<h6> STEP 5\uff1a\u7528\u81ea\u7136\u8a9e\u8a00\u8acb Copilot \u751f\u6210\u5100\u8868\u677f<\/h6>\n<p>\u76f4\u63a5\u8907\u88fd\u4ee5\u4e0b\u6307\u4ee4\u8cbc\u5165 Copilot \u5c0d\u8a71\u6846\uff1a <\/p>\n<p>&lt;?XML:NAMESPACE PREFIX = &#8220;[default] http:\/\/www.w3.org\/2000\/svg&#8221; NS = &#8220;http:\/\/www.w3.org\/2000\/svg&#8221; \/&gt;<\/p>\n<pre><code>\u8acb\u5efa\u7acb\u4e00\u9801 CSP \u8a02\u55ae\u7e3e\u6548\u7e3d\u89bd\u5100\u8868\u677f\uff0c\u5305\u542b\uff1a\n1. \u6bcf\u6708\u8a02\u55ae\u6210\u4ea4\u91d1\u984d\u8da8\u52e2\u6298\u7dda\u5716\uff08\u4f9d\u958b\u55ae\u65e5\uff09\n2. \u5404\u7522\u54c1\u5206\u985e\u7684\u6210\u4ea4\u672a\u7a05\u5c0f\u8a08\u9577\u689d\u5716\n3. \u5404\u696d\u52d9\u7684\u8a02\u55ae\u6578\u91cf\u8207COST\u5c0f\u8a08\u6392\u884c\n4. \u8a02\u55ae\u72c0\u614b\u5206\u4f48\u5713\u9905\u5716\n5. \u5404\u7d93\u92b7\u5546\u7684\u696d\u7e3e\u8ca2\u737b\u6392\u540d<\/code><\/pre>\n<hr>\n<h6> \u5efa\u8b70\u751f\u6210\u7684\u5100\u8868\u677f\u9805\u76ee\uff08\u4f9d\u4f60\u7684\u8cc7\u6599\u6b04\u4f4d\u91cf\u8eab\u8a2d\u8a08\uff09<\/h6>\n<p>\u985e\u578b<br \/>\u5100\u8868\u677f\u9805\u76ee<br \/>\u4f7f\u7528\u6b04\u4f4d<\/p>\n<p> \u8da8\u52e2<br \/>\u6bcf\u6708\u6210\u4ea4\u91d1\u984d\u8d70\u52e2<br \/>\u958b\u55ae\u65e5\u3001\u6210\u4ea4\u50f9\u672a\u7a05\u5c0f\u8a08<\/p>\n<p> \u8da8\u52e2<br \/>\u6bcf\u6708\u8a02\u55ae\u7b46\u6578<br \/>\u958b\u55ae\u65e5\u3001\u524d\u53f0\u9700\u6c42\u55ae\u865f<\/p>\n<p> \u5206\u4f48<br \/>\u8a02\u55ae\u72c0\u614b\u5206\u4f48<br \/>\u8a02\u55ae\u72c0\u614b<\/p>\n<p> \u5206\u4f48<br \/>\u8a02\u95b1\u52d5\u4f5c\u6bd4\u4f8b\uff08\u65b0\u8cfc\/\u7e8c\u7d04\/\u52a0\u8cfc\uff09<br \/>\u8a02\u95b1\u52d5\u4f5c<\/p>\n<p> \u6392\u884c<br \/>\u5404\u7522\u54c1\u5206\u985e\u696d\u7e3e\u8ca2\u737b<br \/>\u7522\u54c1\u5206\u985e\u3001\u6210\u4ea4\u50f9\u672a\u7a05\u5c0f\u8a08<\/p>\n<p> \u6392\u884c<br \/>\u696d\u52d9\u500b\u4eba\u696d\u7e3e\u6392\u884c<br \/>\u5c55\u7881\u696d\u52d9\u3001\u6210\u4ea4\u50f9\u672a\u7a05\u5c0f\u8a08\u3001\u6578\u91cf<\/p>\n<p> \u6392\u884c<br \/>\u7d93\u92b7\u5546\u696d\u7e3e\u6392\u540d Top 10<br \/>\u7d93\u92b7\u5546\u3001\u6210\u4ea4\u50f9\u672a\u7a05\u5c0f\u8a08<\/p>\n<p> \u6392\u884c<br \/>\u6700\u7d42\u5ba2\u6236\u63a1\u8cfc\u91d1\u984d Top 10<br \/>\u6700\u7d42\u5ba2\u6236\u3001\u6210\u4ea4\u50f9\u672a\u7a05\u5c0f\u8a08<\/p>\n<p> KPI \u5361<br \/>\u7e3d\u6210\u4ea4\u91d1\u984d \/ \u7e3dCOST \/ \u6bdb\u5229\u7387<br \/>\u6210\u4ea4\u50f9\u672a\u7a05\u5c0f\u8a08\u3001\u5c55\u7881COST\u672a\u7a05\u5c0f\u8a08<\/p>\n<p> KPI \u5361<br \/>\u7e3d\u8a02\u55ae\u7b46\u6578 \/ \u7e3d\u6388\u6b0a\u6578\u91cf<br \/>\u524d\u53f0\u9700\u6c42\u55ae\u865f\u3001\u6578\u91cf<\/p>\n<p> \u5206\u6790<br \/>\u5404\u5546\u54c1\u540d\u7a31\u92b7\u552e\u91cf Top 20<br \/>\u5546\u54c1\u540d\u7a31\u3001\u6578\u91cf\u3001\u6210\u4ea4\u50f9\u672a\u7a05\u5c0f\u8a08<\/p>\n<p> \u5206\u6790<br \/>\u696d\u52d9\u90e8\u9580 vs COST\u6bdb\u5229\u5206\u6790<br \/>\u5c55\u7881\u696d\u52d9\u90e8\u9580\u3001\u6bdb\u5229\uff08\u8a08\u7b97\u6b04\uff09<\/p>\n<hr>\n<h6> Copilot \u53ef\u4ee5\u8f38\u5165\u7684\u81ea\u7136\u8a9e\u8a00\u7bc4\u4f8b<\/h6>\n<ul>\n<li><code>\u300c\u5efa\u7acb\u6bcf\u6708\u6210\u4ea4\u91d1\u984d\u6298\u7dda\u5716\uff0cX\u8ef8\u70ba\u958b\u55ae\u65e5\uff08\u6708\u4efd\uff09\uff0cY\u8ef8\u70ba\u6210\u4ea4\u50f9\u672a\u7a05\u5c0f\u8a08\u7684\u52a0\u7e3d\u300d<\/code>\n<li><code>\u300c\u7528\u9577\u689d\u5716\u986f\u793a\u5404\u5c55\u7881\u696d\u52d9\u7684\u7e3d\u6210\u4ea4\u91d1\u984d\uff0c\u7531\u9ad8\u5230\u4f4e\u6392\u5e8f\u300d<\/code>\n<li><code>\u300c\u5efa\u7acb KPI \u5361\u7247\uff0c\u986f\u793a\u7e3d\u6210\u4ea4\u91d1\u984d\u3001\u7e3d\u6578\u91cf\u3001\u5e73\u5747\u55ae\u50f9\u300d<\/code>\n<li><code>\u300c\u5efa\u7acb\u77e9\u9663\u8868\uff0c\u5217\u70ba\u7522\u54c1\u5206\u985e\uff0c\u6b04\u70ba\u8a02\u95b1\u52d5\u4f5c\uff0c\u503c\u70ba\u6210\u4ea4\u91d1\u984d\u52a0\u7e3d\u300d<\/code><\/li>\n<\/ul>\n<hr>\n<blockquote>\n<p>\u26a0\ufe0f <strong>\u6ce8\u610f<\/strong>\uff1aCopilot \u529f\u80fd\u9700\u8981 <strong>Power BI Premium \/ Fabric F64 \u4ee5\u4e0a\u5bb9\u91cf<\/strong>\uff0c\u6216 <strong>Power BI Pro + Premium Per User (PPU)<\/strong> \u6388\u6b0a\u624d\u80fd\u4f7f\u7528\u3002\u5982\u679c\u770b\u4e0d\u5230 Copilot\uff0c\u8acb\u78ba\u8a8d\u6388\u6b0a\u7b49\u7d1a\u3002<\/p>\n<\/blockquote>\n<p>\u6709\u4efb\u4f55\u6b65\u9a5f\u5361\u4f4f\uff0c\u544a\u8a34\u6211\u662f\u54ea\u4e00\u6b65\uff0c\u6211\u53ef\u4ee5\u5e6b\u4f60\u9032\u4e00\u6b65\u8aaa\u660e\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5b8c\u6574 Step-by-Step \u6559\u5b78\uff1aExcel \u2192 Fabric \u2192 Power BI Copilot \u5100\u8868\u677f Fabric \u8a66\u7528\u5bb9\u91cf &#8211; Mic&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":3308,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[34],"tags":[],"_links":{"self":[{"href":"http:\/\/i-services.info\/cspclm\/index.php?rest_route=\/wp\/v2\/posts\/3309"}],"collection":[{"href":"http:\/\/i-services.info\/cspclm\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/i-services.info\/cspclm\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/i-services.info\/cspclm\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/i-services.info\/cspclm\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3309"}],"version-history":[{"count":2,"href":"http:\/\/i-services.info\/cspclm\/index.php?rest_route=\/wp\/v2\/posts\/3309\/revisions"}],"predecessor-version":[{"id":3313,"href":"http:\/\/i-services.info\/cspclm\/index.php?rest_route=\/wp\/v2\/posts\/3309\/revisions\/3313"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/i-services.info\/cspclm\/index.php?rest_route=\/wp\/v2\/media\/3308"}],"wp:attachment":[{"href":"http:\/\/i-services.info\/cspclm\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/i-services.info\/cspclm\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3309"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/i-services.info\/cspclm\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}