Forum Discussion

katherine_stz's avatar
katherine_stz
Frequent Visitor
4 years ago

How to extend Power BI service timeout limit

I have a report using DirectQuery on an extremely large dataset in SQL (over 30 GB). I'm running into a timeout issue on Power BI service because some queries take up to 10 minutes to load and the li...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, katherine_stz 

 

Have you tried entering timeout minutes when connecting?

Like this:

 

Best Regards,

Community Support Team _Janey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello v-janeyg-msft ! Can I ask if this means that this setting will be carried over to Power BI Service? We are connecting to an on-prem SQL Server using a Gateway.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    The answer is a definite maybe.  If you specify it in Power Query then it will most likely be honored unless your data source enforces its own (lower)  limits.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Got this, thank you.