Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
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
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
@Hi, @Mahesh0016 Just a couple of things you can try from your side:
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.
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!
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
|
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
74 | |
71 | |
39 | |
27 | |
27 |
User | Count |
---|---|
97 | |
97 | |
58 | |
45 | |
42 |