Forum Discussion
Ant_C
2 years agoFrequent Visitor
Power Automate - Power BI DAX Query timeout
Hello, I have a Power Automate flow in which I use a "Run query against a dataset" action for Power BI. The query is a bit long to run (around 2.5 minutes, tested it in DAX Studio) and I get a ...
lbendlin
2 years agoSuper User
Might be worth trying to do this via your own custom connector.
Just to see if you also hit the two minute timeout.
In general any query that runs longer than 5 seconds "has room for improvement".
- Ant_C2 years agoFrequent Visitor
Thanks for the reply.
Any guide online on how to create this custom connector, or how you did it ? We currently don't have any service principal so I don't know if it's possible without it
Best regards- lbendlin2 years agoSuper User
You don't need a service principal, but it surely makes life a little easier.
Here's the guide: Custom connectors overview | Microsoft Learn