Forum Discussion
Solved
How 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 w...
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/
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/