Azure SQL - Power BI / Allow Azure Services and resources to access this server disables automatially

Question

Hello everyone,

I have an Azure SQL database and I want to let my clients read the data via Power BI service. My clients are therefore using a different tenant than mine. I understand that the option "Allow Azure Services and resources to access this server" enables a connection between Azure SQL and Power BI Service (not sure this works cross tenants or not). At first view this setup seems to work, but the option disables itself after several days.

What I mean is that if I enable "Allow Azure Services and resources to access this server" I will find it disabled the week after. I get no error message, nothing. I made severa attemps, and everytime it becomes disabled again.

Should I give up on this option and setup a gateway ? Any idea please ?

Kind Regards,

Answer 1

Hello @Chris !

Welcome to Microsoft QnA!

It is quite strange , but it could have an explanation

Can you find anything in the Activity Logs of the SQL ?

What SQL DB Tier are you using ? Is it Serverless ? It is strange but maybe the pause due to inactivity switch , triggers the behavior ? I dont find it logical.....

Please inspect the Activity Logs !

Anyway the Best Practice instructs the use of Private Link

Private Link

Private Link allows you to connect to a server via a private endpoint. A private endpoint is a private IP address within a specific virtual network and Subnet.

If your endusers are also coming via Azure Subscriptions it is quite easy to Setup the Service

https://learn.microsoft.com/en-us/azure/azure-sql/database/private-endpoint-overview?view=azuresql

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards