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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dilkushpatel
Helper III
Helper III

Azure DW Direct Query Performance Issue

Hi,

I have designed few reports which fetches data directly from Azure DW.

While deploying i have selected use cloud connection insted of gateway as I though both being MS cloud offering they might talk well together directly.

So far on desktop everything had worked pretty much well except few instances of errors.

 

Once i deployed on power BI web I'm having almost 75% error rate.

 

usual error:

Couldn't load the data for this visual
 
Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support and provide the following details to help resolve your issue faster.
 
I'm not able to understand what the issue is here.
 
Any help on this?
 
Thanks,
Dilkush

 

2 REPLIES 2
ankitpatira
Community Champion
Community Champion

@dilkushpatel I am not 100% sure but vaguely remember coming across this. If you have date time field in your reports can you try changing it to Date and see if that works ? I think there is some bug with mappings using DirectQuery. As I said not 100% sure.

Hi @ankitpatira
Renamed majority of datetime columns to Date still no significant difference.

Thanks for the advice though.

 

Some of my tables are very wide in terms of number of columns, could that be one issue behind slowness?


Even on desktop app it takes 2-3 minute sofr data to come up.

 

I have removed few rows and renamed few using desktop tool so does that add some complexity to query performance?

 

Thanks,

Dilkush

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors