question

ChandAnupamSBOBNGITARX-7207 avatar image
0 Votes"
ChandAnupamSBOBNGITARX-7207 asked AnuragSharma-08 commented

PowerBi auto refresh from SQL DB without userid and password

We have a PowerBI report with a auto refresh setup to fetch data from an Azure SQL DB. My question was whether there is any more secure way to to connect PowerBi Saas and my SQL DB without the use of userid and password? Is there a way to use Service principal/oAuth or something similar?

azure-sql-database
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ChandAnupamSBOBNGITARX-7207, welcome to Microsoft Q&A forum.

You can use Microsoft Account to authenticate using AAD authentication:

Support for Azure Active Directory authentication for Azure SQL Database & Data Warehouse connectors

202304-image.png



0 Votes 0 ·
image.png (30.5 KiB)

Isn't Microsoft User for a Person? I'm looking for refreshing the data/report automatically using a system credential(similar to Service Principal). Can you share documentation on how to create a Microsoft account for a system/service?

0 Votes 0 ·
AnuragSharma-08 avatar image AnuragSharma-08 ChandAnupamSBOBNGITARX-7207 ·

I think we need to reach out to Power BI community that would be better place to answer these specific queries:

Microsoft Power BI Community


0 Votes 0 ·

0 Answers