cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sifar786
Post Patron
Post Patron

Create Dataflow for company SQL Database accessed via VPN

Hi,

 

I have an SQL Database on company network that can be accessed only thru company VPN installed on my system. I am able to do so with Power BI Desktop if VPN is  switched on i.e. i am authenticated on VPN. But if i try to copy the same M-code and try to create a dataflow in Power BI Service online, by pasting the M-code, it does not work but gives `Unexpected error`.

 

Any viable solutions on how to create a Power BI Dataflow that can access this database? Please note that once this dataflow gets created, it will be used by many other users for creating their dashboards and reports.PowerBI Dataflow error for SQL Database credentials.jpg

1 ACCEPTED SOLUTION

Yes, there might be gateway already installed in your Org netwrok, Are you Power BI admin in your Org

If Yes - Configure a new gateway as suggested in previous reply

If Not - Please reach out you Power BI Admin team, they would be able to help to access the dateway

 

The gateway option will be greayed out untill you do not have access to a gateway/datacource

 

If this post helps, then please consider Accept it as the solution and give it a thumbs up


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

View solution in original post

6 REPLIES 6
arvindsingh802
Super User
Super User

To access on Premise data from Dataflow you would need Power BI Gateway

On-premises data gateway - Power BI | Microsoft Docs

 

If this post helps, then please consider Accept it as the solution and give it a thumbs up


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

You mean a personal gateway or a standard one? if standard one, where does it get installed and how does one configure it, so that it can be used by all PBI Service users in org?

Enterprise Gateway will let multiple users to use same gateway

Install the gateway on Server running 24*7  & within your organization network so it will not require VPN  and once configured it can be accessed from anywhere to manage data sources from manage gateway option

 

To Configure Use the on-premises data gateway app | Microsoft Docs

 

If this post helps, then please consider Accept it as the solution and give it a thumbs up

 


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

Just curious...If my Co or org has an enterprise VPN, wouldn't that mean that an Enterprise gateway maybe already installed on the Co network? Or is VPN different from an Enterprise gateway? How do they work for the PBI Service?

Right now, if i open an Dataflow on my Power BI service and check its Settings > Gateway connection, i see that it is greyed out and Off. I cannot click it. So my question is, if my Co has an Enterprise gateway, what should i do or ask them to do, to make it show up here?

sifar786_0-1624005589548.png

 

Yes, there might be gateway already installed in your Org netwrok, Are you Power BI admin in your Org

If Yes - Configure a new gateway as suggested in previous reply

If Not - Please reach out you Power BI Admin team, they would be able to help to access the dateway

 

The gateway option will be greayed out untill you do not have access to a gateway/datacource

 

If this post helps, then please consider Accept it as the solution and give it a thumbs up


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

View solution in original post

Thanks Arvind.

I will reach out to my PBI Admin team and see if they can help us access the gateway.

Cheers!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!