Forum Discussion

prathyoo's avatar
prathyoo
Advocate II
4 years ago

Creating CSV file in Sharepoint from Power BI Dataflows

We have a Power BI dataflow with 64 tables (Power Queries) and this dataflow is the single source of truth for quite a few of our reporting. The tables in the dataflow start as SQL queries to on-prem...
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

prathyoo : Thank you for all the details. We have something similar requirement. Extracting Power BI dataflow tables to CSV. I have two questions here,

1. Can we automate this to run and generate CSV files ? If yes, then how ?

2. When we generate CSV file, is there any way to not override the previous data and maintain history in the CSV files?

 

Thank you in advance.

 

Regards,

Jyoti 

  • prathyoo's avatar
    prathyoo
    Advocate II
    4 years ago

    Hi Anonymous ,

     

    1. Yes - If you notice the power automate we are using, we have triggered it to run as soon as the dataflow is refreshed. And, the dataflow itself has been set to refresh daily. This is the way we have automated our solution.

     

    2. In our case, when the csv file is generated, we have created the file names to include the timestamp. This ensures uniqueness and prevents overwriting. You could also use the time stamp to create folders in sharepoint and that will also serve you need.

     

    Regards,

    Prathyoo

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      prathyoo : Thank you so much for your answer.