Forum Discussion
Post PatronHow to export data in excel format from PBI to SharePoint folder using power automate?
Hello all,
I am struggling with exporting excel data to SharePoint folder from Power bi using Power automate.
In power automate flow, there is option to create a CSV table and the flow works if I want to create a CSV file, however my scenario is I want the file in Excel format so that users can get there to filter the data on respective fields they want. Since, filtering is not available in CSV format.
I watched a lot of youtube videos and nothing really works for me.
My scenario is running a query against dataset in power bi using a DAX.
Is there a better way that I am missing? Can you please help. Relly urgent!!!
Appreciate your time.
thanks
pthapa
If you want filters, you have to create a table in the Excel file and then add your query a dataset rows to it unless you have premium/paginated.
Matthew Devaney did a good tutorial here, you could adapt this for your datasource: https://www.matthewdevaney.com/create-an-excel-file-and-add-rows-using-power-automate/
2 Replies
- christinepayton
Most Valuable Professional
If you want filters, you have to create a table in the Excel file and then add your query a dataset rows to it unless you have premium/paginated.
Matthew Devaney did a good tutorial here, you could adapt this for your datasource: https://www.matthewdevaney.com/create-an-excel-file-and-add-rows-using-power-automate/
pthapaThank you for sharing, I will take a look at the shared resources.
Appreciated!!!pthapa