Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
AnkitKukreja
Super User
Super User

VNET Data Gateway

Hi All,

 

We have a data source as Azure SQL (in Azure) and we are creating Power BI reports out of this Database. We are creating the Power BI reports on a laptop that is in the customer’s network. We have deployed the VNET data gateway through the Power Platform admin portal and connected it to Azure VNET. We have also created a connection inside the VNET data gateway and the user has access to the dataset and VNET data gateway connection.

 

We want all the traffic from Power BI to the Data Source ( Azure SQL) should use the VNET data gateway and we should be able to verify it.

 

But as of now, we are not getting that “Gateway Connection” option enabled on the Power BI dataset.

 

AnkitKukreja_0-1624347652260.png

The customer doesn't have a gateway on his machine and is reluctant to download that as he says this is not the requirement for the VNET.

Please advise some troubleshooting steps or documentation for the same.

 

Thanks,

Ankit

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
https://topmate.io/ankit_kukreja
1 ACCEPTED SOLUTION
AnkitKukreja
Super User
Super User

The VNET data gw doesn't require any additional gateway in the user's system or VM. That's the beauty of the VNET data gw. 
The issue was that the user was not having perms on that dataset, we assigned the perms for the gw under Manage Gateway there is an option for "Administrators" and add the user as Admin.
Also, while adding a data source to the gw there is the option "Users" to add that user in there as well.

That 2 perms were missing in my case.


Thanks,

Ankit

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
https://topmate.io/ankit_kukreja

View solution in original post

4 REPLIES 4
AnkitKukreja
Super User
Super User

The VNET data gw doesn't require any additional gateway in the user's system or VM. That's the beauty of the VNET data gw. 
The issue was that the user was not having perms on that dataset, we assigned the perms for the gw under Manage Gateway there is an option for "Administrators" and add the user as Admin.
Also, while adding a data source to the gw there is the option "Users" to add that user in there as well.

That 2 perms were missing in my case.


Thanks,

Ankit

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
https://topmate.io/ankit_kukreja
v-kkf-msft
Community Support
Community Support

Hi @AnkitKukreja ,

 

Does your problem have been solved? If it is solved, please mark a reply which is helpful to you.

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

 

Best Regards,

Winniz

v-kkf-msft
Community Support
Community Support

Hi @AnkitKukreja ,

 

Please see if these documents are helpful:

 

Announcing VNet Connectivity for PBI Datasets (Public Preview) 

Securing the connection between Power BI and Azure SQL Database 

Secure Access to Azure SQL Servers for Power BI 

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

collinq
Super User
Super User

Hi @AnkitKukreja ,

 

Just to clarify, if data is sitting inside an organization's firewall, there has to be a gateway.  The gateway should be installed on a server or other machine that does not go down.  That said, you can install a personal gateway but that means that the machine the personal gateway is installed on should not be turned off ever if it will conflict with the refresh times.

 

If the data is cloud based, then a gateway is not needed.

 

If you are using a laptop in the customer's network and the data is cloud based, they do not need to use a gateway.  The error is probably happening because the connection strings are different in desktop than the service if you are trying to do something with a gateway in between.

The desktop file should be fine getting to the cloud data.  Then, just publish that and do not connect it to the gateway you set up and assuming all other things being set correctly, it should work.

 




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

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors