cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mbjohnson Helper I
Helper I

Error - Couldn't load the data for this visual

We have a report with several different visuals. Sporadically, one or more of the visuals on the published embedded report that the users see will display this...

 

ErrorX.PNG

 

After clicking "See details", it shows the following error message (with different ID and time field values)...

 

Error2.PNG

 

We are using DirectQuery and the Power BI gateway. At times, refreshing the page populates the visual correctly and sometimes it can take longer for refreshes to work. Any thoughts on what is going on here and how to correct the issue?

1 REPLY 1
Community Support
Community Support

Re: Error - Couldn't load the data for this visual

Hi @mbjohnson,


Based on error message and your description, it seems like networks issue.

Can you ensure your gateway can connect to datasource smoothly?

If this is a case, I'd like to suggest you move your gateway to a stable network to refresh.

 

In addition, you can try to use below methods to provide more detailed information about this issue. It will be help for troubleshooting:

Troubleshooting the On-Premises Data Gateway

 

Tools for troubleshooting

 

Collecting logs from the gateway configurator

There are several logs you can collect for the gateway. Always start with the logs!

Installer logs

%localappdata%\Temp\On-premises_data_gateway_*.log

Configuration logs

%localappdata%\Microsoft\on-premises data gateway\GatewayConfigurator*.log

On-premises data gateway service logs

C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log

Event Logs

The On-premises data gateway service event logs are present under Application and Services Logs.

on-prem-data-gateway-event-logs

Fiddler Trace

Fiddler is a free tool from Telerik that monitors HTTP traffic.  You can see the back and forth with the Power BI service from the client machine. This may show errors and other related information.

 

BTW, you can also try to install your gateway on device which contains the datasource, it will increase the refresh performance.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors