Forum Discussion
Exporting to CSV (Power Automate Button)
Hi there,
I have created a button to export to CSV (https://www.youtube.com/watch?v=BnTipbooeP0), which works perfectly on my powerbi service area. I have a PRO account.
Although I share one report with "Publish to Web", and here the Button does not work as I suspected.
Is there a way for a user to export a CSV file with a free account, or he must be PRO also.
Thanks
Hi campelliann ,
I saw the same situation as you in the video comments, the button will not trigger after setting 'Publish to web'.
You can export data to CSV from Power BI by the following ways:
1.Copy Data from Data View in Power BI Desktop and Paste it to Destination
2.Copy Data from Query Editor in Power BI Desktop and Paste it to Destination
3.Export Data from Power BI Desktop to CSV or TXT Using DAX Studio
4.Importing Power BI Desktop Directly to Excel
5.Export the data that was used to create a visualization to Excel
Reference:
Exporting Data from Power BI Desktop to Excel and CSV – Part 1: Copy & Paste and DAX Studio Methods
Export data from a Power BI visualization - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Campellian,
Refer >> Solved: Export data with free user - Microsoft Power BI Community
Free users can export data from report to PowerPoint, csv/excel. In the following official articles, it doesn't mention that license is required to export data.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-publish-to-powerpoint/
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-export-data/Regards,
Ritesh
Please mark the answer if useful so that it can help others as well
Hi campelliann ,
I saw the same situation as you in the video comments, the button will not trigger after setting 'Publish to web'.
You can export data to CSV from Power BI by the following ways:
1.Copy Data from Data View in Power BI Desktop and Paste it to Destination
2.Copy Data from Query Editor in Power BI Desktop and Paste it to Destination
3.Export Data from Power BI Desktop to CSV or TXT Using DAX Studio
4.Importing Power BI Desktop Directly to Excel
5.Export the data that was used to create a visualization to Excel
Reference:
Exporting Data from Power BI Desktop to Excel and CSV – Part 1: Copy & Paste and DAX Studio Methods
Export data from a Power BI visualization - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
