Error Directquery

[Anonymous]

I have the following scenario, I have a hacker that has access to some database, and I have some applications of power bi that use these databases in the import data mode, the loads of those applications are done once a day and I use for this the On-premises data gateway and everything works normally.

But now the need arose to develop a dashboard that will use data from a sql server database that is on the web, that is, I can access it from anywhere and this dashboard will work via directquery, that is, it will consume the data Of this bank in real time.

I did a test uploading to the power bi portal a version of this dashboard that I have already developed and the following error is occurring when I try to access this dashboard:

"This data source can not be accessed by a data gateway: xxx.xxx.xx.xxx server, Database: xxx"

And provides a link that takes me to the comparison page between Personal gateway (which I do not use) with the On-premises data gateway (which is what I'm already using)

I set up the connection of this dashboard in the panel of managing gateways of the portal of the power bi passing exactly the same data that I pass in the moment of loading the data that I do in that application when I am developing in it.

How can I make this direct query function work with this database?

[v-caliao-msft · Accepted solution]

@Anonymous,

But now the need arose to develop a dashboard that will use data from a sql server database that is on the web

Do you mean you are trying to connect SQL Azure database with directQuery mode?

With DirectQuery, queries are sent back to your Azure SQL Database as you explore the data in the report view. This experience is suggested for users who are familiar with the databases and entities they connect to. Please refer to the link below to see the details about connect directly to Azure SQL Database.
https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-sql-database-with-direct-connect/

Regards,

Charlie Liao