PowerBi auto refresh from SQL DB without userid and password
Chand, Anupam SBOBNG-ITA/RX
451
Reputation points
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?