cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Data Flow, SQL Server on the cloud, gateways

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

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: Data Flow, SQL Server on the cloud, gateways

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".


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Community Support
Community Support

Re: Data Flow, SQL Server on the cloud, gateways

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.

Highlighted
New Member

Re: Data Flow, SQL Server on the cloud, gateways

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

 

 

Community Support
Community Support

Re: Data Flow, SQL Server on the cloud, gateways

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.

Support Ticket.gif

 

 

Best Regards,

Icey

 

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

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.