Error - Couldn't load the data for this visual

[Anonymous]

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...

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

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?

[Anonymous]

Hi @Anonymous,

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.

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