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 

 

This is the code after I use DQ mode to connect SQL and add 10min timeout when connecting, you can reference:

If it doesn't work, Please feel free to ask me.

 

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.

DigestDataHumbl's avatar
DigestDataHumbl
Frequent Visitor
1 year ago

When I try to do that, I also get errors just as lbendlin. Mine says, 
'CommandTimeout' are not valid options. Valid options are: 'CreateNavigationProperties.'
How are you avoiding the error or how would you use this valid option?