How to export data in excel format from PBI to SharePoint folder using power automate?

[pthapa]

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

[pthapa]

Thank you for sharing, I will take a look at the shared resources.
Appreciated!!!

pthapa

[christinepayton · Accepted solution]

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/