Forum Discussion
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...
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
prathyoo : Thank you so much for your answer.