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
Mahesh0016
Super User
Super User

Error Fetching Data for Visual in DirectQuery Mode – Need Optimization Advice

Hello Community,

I’m working with a DirectQuery-mode table that contains only 8 records. The data loads successfully in Power Query, but when I load it into Power BI Desktop, it takes a significant amount of time.

Additionally, when I try to plot a simple column in a table visual, I receive the following error:

Error Message:
"Error fetching data for this visual"

Detailed Message:
"A connection could not be made to the data source with the Name of
{"protocol":"tds","address":{"server":"XXXXXXXXXXX.database.windows.net","database":"XXXXX"},"authentication":null,"query":null}"

Has anyone encountered this issue before? If you have any suggestions or optimization tips to resolve this, I’d really appreciate your help.

Thank you in advance!

4 REPLIES 4
v-pgoloju
Community Support
Community Support

Hi @Mahesh0016,

 

Just following up to see if the solutions provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

 

Best regards,
Prasanna Kumar

v-pgoloju
Community Support
Community Support

Hi @Mahesh0016,

 

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @Royel  and @tharunkumarRTK  for their prompt and helpful responses.

 

Just following up to see if the solutions provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

 

Best regards,
Prasanna Kumar

Royel
Resolver II
Resolver II

@Hi, @Mahesh0016  Just a couple of things you can try from your side:

  1. Test the query in another tool – Try running it in SSMS or Azure Data Studio to see how long it takes. Sometimes when the server is under load, it might respond more slowly than usual. So even if it’s fast now, it’s worth checking how it behaves at different times.

  2. Try switching to Import mode – Since the data seems to load fine in Power Query, but not in the visual, try using Import mode instead of DirectQuery. It’s a good way to test if the delay is due to live queries or something else. You might see the visual loading faster this way.

 

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!

tharunkumarRTK
Super User
Super User

@Mahesh0016 

From the server hostname you shared, I guess your database is hosted in Azure.

 

Have you tried querying the db from any other client tool other than power bi, if yes then how long it is taking?

 

As you have mentioned the data load from power query to power bi is taking longer, I suggest you check the db logs and see how much time the query execution is taking. If it is not that long then I would suggest you check the network traces 

 

Look at the network routing and see if the traffic from your machine to the db server is taking longer route or shorter route. If required leverage network watcher in Azure. Depending the results you can talk to your network team to fix the routing table. 

 

 

 

 

 

 

Connect on LinkedIn

 

 

 








Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!


PBI_SuperUser_Rank@2x.png

 

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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.