Export excel form Power BI using Power Automate

[simo954]

Hi people 👋

I'm trying to extract data from a specific table in power bi and export it to an excel file for further analysis recursively (1 a week).

I came across a solution, but I am encountering some issues. Here is the solution I found: 

1) The solution I found only works on an import mode dataset, but my final goal is to run the query against a dataset in live connection with an Azure Analysis Services database. Unfortunately, my current solution cannot support live connection datasets, and I cannot change the connection mode of the dataset.

2) I attempted to use Power BI Report Builder, but I am unable to connect my report to Azure due to internal policies.

3) I cannot use PowerShell or other similar solutions because it needs to be easy to maintain.

4) I cannot export data in xlsx format with live connection 

Despite these constraints, I am hoping for suggestions for a workaround 🙂

Thanks ❤️