Dataset as a csv file in Sharepoint

[Anonymous]

Hi,

I have created a dataset merging two or more dataset, Now i want my finalDataset to store as a csv file in a sharepoint. Is this doable?
If so how can i achieve it

Regards,

Tamilselvi K

[v-yingjl]

Hi @Anonymous ,

If you want to export it as a csv file in SharePoint manually, the most direct way is that you can use a table visual to show your data in power bi desktop, then export the table as a csv file and upload it to SharePoint.

If you want to export it automatically, you can try to use Power Automate to craete a flow, create your datasource as a dataflow and use PowerAutomate to export it to SharePoint as a csv file automatically.

Please refer:

1. Using Power Query And Microsoft Flow To Automate The Creation Of CSV Files 
2. Exporting Data from Power BI Desktop to Excel and CSV 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat · Accepted solution]

Depending on how many rows you have, there are multiple ways to do this (listed below); however, if you plan is to provide this CSV for others to do data analysis/visualization, you should consider used a Power BI Dataflow or Dataset instead.

- Make a table visual with all desired columns and export data as CSV

- Use the Power Automate visual to send the data to a Flow and create the csv file

- Copy the whole table and paste in Excel, save as CSV

- Make a simple Paginated Report and subscribe to it as a CSV and export it on demand

- Use DAX Studio

Pat