The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi
I have a SQL server running on a VM in Azure and trying to direct query it via power BI but are unable to. Getting below error.
Couldn't load the data for this visual Your data gateway (Power Bl — personal) is offline, but a data gateway is available. Please try again later or contact support. If you contact support, please provide these details. Error Code DMTS_NoGatewayWithAllDatasourcesToBindError Server xxxxx.northeurope.cloudapp.azure.com Correlation ID d8d1c97f-2eb6-3310-976f-839a6eb0097a Database quotewerks ConnectionType (FieldValueh Activity ID c162aad3-537e-41b9-bb62-fOc01819b04a Request ID 0044ec97-23c9-31bd-8fac-b7a6d80dOb2f Time Thu Jan 19 2017 GMT+OOOO (GMT Standard Time) Version 13.0.1700.1007 Cluster URI
I can connect to the SQL database via Excel and PowerBI desktop. Also have the enterprise gateway installed on the SQL server, and the dataset configured within PowerBI but still unable to refresh the data.
ANy help would be great
Hi @tmears,
Have you added the SQL Server data source under enterprise gateway following instructions in this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-sql/ ?
Please make sure that the data source information you add under the gateway matches exactly what you configure in Power BI Desktop, in other words, the server name and database name should completely match between Power BI Desktop and the data source within the on-premises data gateway.
Thanks,
Lydia Zhang
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
142 | |
109 | |
107 | |
74 | |
61 |
User | Count |
---|---|
266 | |
127 | |
119 | |
100 | |
88 |