Forum Discussion
Power BI displays visuals in Desktop version, but cannot display the visual in PowerBI on-line
When we create a report using a composit model, with 2 direct queries and 2 import queries...we are able to view the report data in Power BI desktop, but when we publish the same report in Power BI online/services we couldn't view few of the report slides with error message 'couldn't load the data for this visual'.
We tried to create all the 4 queries using import query model, the issue has disappeared.
Could you please help me to understand why we facing the issue when using composite model (direct query+import query)?
Thank in advance!
Hi Anonymous ,
Please install and configure the gateway.
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install
You can add data sources that can be used with the gateway.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql
You can also refer to this document if necessary.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Anonymous , In case direct query is gateway set up properly
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages
- V-lianl-msft
Community Support
Hi Anonymous ,
Please install and configure the gateway.
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install
You can add data sources that can be used with the gateway.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql
You can also refer to this document if necessary.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.