Go to Date View<\/strong> and select the table you want to export, select Copy Table<\/strong> and then paste it in Excel.<\/p>\n\n\n\n 2. You need to find Power BI Desktop local port number from the Power BI Desktop temp directory. Then connect to Power BI Desktop Model from Excel.<\/p>\n\n\n\n For the detailed steps, you could refer to the links below.<\/p>\n\n\n\n http:\/\/biinsight.com\/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-1-copy-paste-and-dax…<\/a><\/p>\n\n\n\n http:\/\/biinsight.com\/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-2-importing-power-bi…<\/a><\/p>\n\n\n\n Please note that if you have millions of rows of data in your Power BI Desktop then you\u2019ll be able to load 1,048,576 rows which is the maximum number of rows limitation on Excel.<\/p>\n","protected":false},"excerpt":{"rendered":" There are some ways to export Power BI Desktop data in Excel. You can copy the entire table, including all DAX calculated columns, very easily and paste it on a destination like Excel.\u00a0This way is good for a small volume of data.\u00a0 Go to Date View and select the table you want to export, select Copy Table and then paste it in Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18,621],"tags":[1012,1013],"class_list":["post-3867","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","category-power-bi","tag-export-a-table-from-power-bi-desktop-to-excel","tag-export-from-power-bi-to-excel"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3867","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3867"}],"version-history":[{"count":1,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3867\/revisions"}],"predecessor-version":[{"id":3869,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3867\/revisions\/3869"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3867"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3867"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<\/figure>\n\n\n\n