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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
bmk
Helper II
Helper II

Direct Query visual - PBI Service timeout

One of the tables in my data model is a Direct Query, underlying data is accessing an Azure SQL database.

I have set a timeout of 25 mins on PBI desktop. The table visual on PBI desktop takes ~13 mins to load. However, it times out on PBI Service.

How can I work to solve this issue?

 

bmk_0-1667503264501.png

 

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @bmk 

 

To me DirectQuery should be used to return the data quickly. There is a timeout to ensure that resources are not exhausted.

 

I would recommend either making the query smaller with using the WHERE clause. Or import the data and refersh it on a schedule.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

1 REPLY 1
GilbertQ
Super User
Super User

Hi @bmk 

 

To me DirectQuery should be used to return the data quickly. There is a timeout to ensure that resources are not exhausted.

 

I would recommend either making the query smaller with using the WHERE clause. Or import the data and refersh it on a schedule.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors