Power BI not able to connect to Azure SQL with private end point

0 votes

I have a VNET configuration in Azure with the following subnet configuration

I login to the VM download PowerBI desktop connect to the database create a report. I publish the report to PowerBI Service.

I am able to access the Azure SQL from PowerBI Desktop and from the VM using "Microsoft SQL Server Management Studio"

When I log in to PowerBI Service and provide credentials for the database access, I cannot access the database.

The error I am getting from powerBI service

Configure database
Failed to update data source credentials: Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny Public Network Access is set to Yes (https://docs.microsoft.com/azure/azure-sql/database/connectivity-settings#deny-public-network-access). To connect to this server, use the Private Endpoint from inside your virtual network (https://docs.microsoft.com/azure/sql-database/sql-database-private-endpoint-overview#how-to-set-up-private-link-for-azure-sql-database).

If I set

  • Deny Public Network Acces to No

and set

  • Allow Azure services and resources to access this server to Yes

Then I can connect to the database from any subscription using the private link, userid & password

With the setting

  • Deny Public Network Acces to No

Access from Azure Data Factory is not an issue, as I can create a privatelink to the database from ADF and use that connection.

Appreciate any help

How can I enable the connection from PowerBI Service

Feb 17, 2022 in Power BI by surbhi
• 3,810 points

1 answer to this question.

0 votes

You'll need to install an on-prem gateway to the VM if you want to keep your Azure SQL settings private and avoid having to monitor the firewall.

I've also been looking for a different approach, but because the Power BI service is in the cloud, there's no way to get it to join the private Azure VNET without installing a gateway on a node inside the network.

You can find the instructions here: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

If you started using the Power BI tool recently, Power BI Training will help you to master its concepts and get hands-on experience with this tool.

answered Feb 17, 2022 by CoolCoder
• 4,400 points

Related Questions In Power BI

0 votes
1 answer

How to connect to sql server from power Bi?

Hi, Follow these steps to connect to SQL ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 33,030 points
0 votes
1 answer

I have a web API with basic authorisation and username and password. How do i connect to it in Power BI?

Hey, @There, I found your query is quite ...READ MORE

answered Oct 29, 2020 in Power BI by Gitika
• 65,910 points
0 votes
1 answer

How to connect Github with power BI?

There are few steps which we need ...READ MORE

answered Nov 19, 2020 in Power BI by Gitika
• 65,910 points
0 votes
1 answer

How to connect google sheet with power bi?

If you're not limited to R Studio, ...READ MORE

answered Dec 22, 2020 in Power BI by Gitika
• 65,910 points
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,130 points
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,570 points
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,360 points
0 votes
1 answer

Query from Power BI to AI suddenly fails with (502): Bad Gateway

The AA Query frequently returns too much ...READ MORE

answered Feb 10, 2022 in Power BI by CoolCoder
• 4,400 points
0 votes
1 answer

Connect BigQuery with Power BI- Best Practice and Cost Effective way

You can use a custom query or ...READ MORE

answered Feb 27, 2022 in Power BI by CoolCoder
• 4,400 points
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP