Forum Discussion
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...
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?
1 Reply
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