how to setup permission to user to connect azure database for power bi user

Anandhswarupp 85

how to setup permission to user to connect azure database for power bi user

Sai Raghunadh M 2,155 Reputation points Microsoft Vendor

2025-01-29T04:08:10.0933333+00:00

Hi @Anandhswarupp

Thanks for the Question and using Microsoft Q&A

Please refer to this similar thread that might help you: https://community.fabric.microsoft.com/t5/Desktop/Connecting-Power-BI-to-Azure-SQL-Server-with-SQL-Authentication/td-p/1477250

Please post this Question in Power BI forum. This will assist you with a faster reply to your query.

Hope this will help.

Thanks

1 answer

Nandan Hegde 33,711 Reputation points MVP

2025-01-29T07:24:26.5633333+00:00
Depending on what type of authentication is supported within your Azure SQL database,

one way is to provide a SQL account to the power bi dev users to authenticate to the Azure SQL database but it is usually not recommended and not a good security standard.

Other way would be AD authentication wherein you would grant the user ID access within the database :

https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?view=azuresql&tabs=azure-portal

so create external user and then grant select access on the necessary objects within the database
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer