0

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: Solution 1

  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 export xlsx

Despite these constraints, I am hoping for suggestions for a workaround :)

Thanks <3

Improve this question

1 Answer 1

Reset to default
0

I created a dataflow that reads data from the db and a dataset that reads data from the dataflow. The power automate flow runs smoothly

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.