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

     

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    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.