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

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft 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