Data Flow, SQL Server on the cloud, gateways

[chriss06]

Hi,

I have been trying to create my data flow and connect it to my SQL Server hosted on the cloud (on Ubuntu 18.04).

The problem is that I receive the following message : "Unexpected error: Session ID ...."

It's working only when I create and use a gateway on-premise installed on my local computer.

But I shouldn't need this gatewate given that my source is not on-premise... And it's not convenient at all because it would mean that my PC has to be open 24/7 if I want to perform regular data refresh.

What could be the easiest solution?

Thanks

[Icey]

Hi @chriss06 ,

Azure SQL Database doesn't support Azure Active Directory authentication.

Reference: 

https://docs.microsoft.com/en-us/power-bi/service-dataflows-create-use#troubleshooting-data-connecti....

Please try this:

Setup a new SQL Server user in Azure SQL Database, and connect via that login, using the 'Basic' Authentication option in Power Query.

Reference: 

https://community.powerbi.com/t5/Service/Connecting-to-Azure-SQL-Database-via-Dataflows-authenticati....

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[chriss06]

Hello @Icey ,

I am not using the Azure Active Directory authentification given that I am not using Azure SQL Database as source.

I was trying to use Microsoft SQL Server as source with a Basic authentification. Is there actually no way to connect to this source through the dataflow without an on-premise PowerBI gateway?

Same problem with MySQL by the way...

Christophe

[Icey]

Hi @chriss06 ,

I guess your SQL Server and MySQL on Ubuntu 18.04 are behind a firewall, require a VPN, or are on virtual networks. Please check.

If so, you might need a data gateway.

If not, I suggest you to create a support ticket to get further help, if you are a pro user.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".