cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Azure SQL Database connection in Power BI service

Hi All, 

 

my data is in Azure MI. So in Power BI Desktop I am using Azure SQL Database connector to fetch data from database in Azure Managed Instance  using VPN. But I am not able to refresh the data in Power BI service. Is it because there we can't use VPN? In Power bI service it says my data is in cloud so i can't use gateway also. Can anyone please help on this.

 

Regards

Vaishali

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Azure SQL Database connection in Power BI service

Hi @Vaishali04 ,

 

If your data sources are behind a firewall, require a VPN, or are on virtual networks, gateway is needed.

cloud.jpg

 

Reference: On-premises data gateway FAQ.

 

 

Best Regards,

Icey

 

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

View solution in original post

2 REPLIES 2
Highlighted
Solution Sage
Solution Sage

Re: Azure SQL Database connection in Power BI service

Hi @Vaishali04 ,

 

If the ports on your firewall are open to allow VPN traffic through it (and back and forth from you Azure Portal) then all should be well.  The issue(s) are most likely that you have to have ports open, permissions, and firewalls set up to allow this to work. You may have to use fiddler to trace your network and see where the error lies.  

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Highlighted
Community Support
Community Support

Re: Azure SQL Database connection in Power BI service

Hi @Vaishali04 ,

 

If your data sources are behind a firewall, require a VPN, or are on virtual networks, gateway is needed.

cloud.jpg

 

Reference: On-premises data gateway FAQ.

 

 

Best Regards,

Icey

 

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

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors