Forum Discussion
tmears
Helper III
Helper IIIDektop 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 (Pow...
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