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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sovereignauto
Helper III
Helper III

Azure Service Tags

Good Morning, 

 

We have a SQL Database Hosted on a Azure VM and have enabled (one at a time) the below service tags on ports 1433,5558 but i still get the error of the server not being accessible. 

 

PowerBi Service Tag, Powerqueryonline Service Tag and the AzureCloud UKsouth and EuropeNorth Service Tags.

 

Does anyone know what service tag needs to be used to use the PowerBi Service to build a Dataflow 

 

Thank you 

2 REPLIES 2
v-xuxinyi-msft
Community Support
Community Support

Hi @sovereignauto 

 

You can try the following methods:

 

  • Ensure that the Network Security Group (NSG) associated with the Azure VM allows inbound traffic for the Power BI service over the required port (the default SQL port is 1433). Check to see if any Deny rules may be overriding Allow rules.

 

  • If you are using an Azure SQL database, make sure you have added the necessary firewall rules to allow connections from Power BI. You can add the Power BI service IP to the Azure SQL database firewall settings.

 

  • If you are still facing problems, please provide any specific error messages you are receiving. This will help diagnose the problem more accurately.

 

For more information on Azure Service Tags, you can read related document link: Azure service tags overview | Microsoft Learn

 

About setting up Azure SQL database firewall rules, you can read related document link:  IP firewall rules - Azure SQL Database and Azure Synapse Analytics | Microsoft Learn

 

Best Regards,

Community Support Team _Yuliax

Hi,

 

Thank you for this.

 

It is a SQL hosted on a Azure VM not a azure SQL.

 

To add the powerbi serivce to the security group do you know what tag is needed to be added? 

We had already added these on the network page of the VM. 

 

PowerBi Service Tag, Powerqueryonline Service Tag and the AzureCloud UKsouth and EuropeNorth Service Tags.

 

Is that the correct tags and correct place? 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors