Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Ant_C
Frequent 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 timeout :

Ant_C_0-1710263575194.png

 

It seems there is a 2 min timeout duration for the request :

Ant_C_3-1710264415086.png

 

Then it seems to retry, but since my query is longer than the timeout value, it keeps retrying without success.

Ant_C_1-1710263802442.png

 

I've tried modifying the timeout duration to 10 minutes in the settings but that didn't change anything 

Ant_C_2-1710263878416.png

This setting doesn't impact request timeout according to the description, but I tried it anyways 😅


I also tried the same query but on a smaller scope of data and it works fine.

How can I increase the timeout duration of the request ?

Thanks in advance for the help.

Best regards

 

3 REPLIES 3
lbendlin
Super User
Super User

Might be worth trying to do this via your own custom connector.  

 

lbendlin_0-1710278362850.png

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".

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

You don't need a service principal, but it surely makes life a little easier.

 

Here's the guide:  Custom connectors overview | Microsoft Learn

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors