Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
tmears
Helper III
Helper III

Dektop top publishing online - Direct Query

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

1 REPLY 1
v-yuezhe-msft
Employee
Employee

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

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.