Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dataset as a csv file in Sharepoint

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...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

     

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

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.