March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
Solved! Go to 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/
Thank you for sharing, I will take a look at the shared resources.
Appreciated!!!
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/
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
40 | |
26 | |
17 | |
11 | |
10 |
User | Count |
---|---|
57 | |
52 | |
23 | |
13 | |
11 |