Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi, @Anonymous
Not supported yet. These data source credentials are indispensable to access the data source.
Currently, Service principal are only allowed as an authentication method for Azure AD applications to access Power BI Service content and APIs.
Best Regards,
Community Support Team _ Eason
The gateway is the only way you'll be able to automatically refresh power bi reports when published to the server.
Hi, @Anonymous
Not supported yet. These data source credentials are indispensable to access the data source.
Currently, Service principal are only allowed as an authentication method for Azure AD applications to access Power BI Service content and APIs.
Best Regards,
Community Support Team _ Eason
In the upper-right corner of the Power BI user interface, select the settings gear icon and then select Settings. Switch to Datasets and select the dataset, such as AdventureWorksProducts, you want to examine. Select the Refresh history link to open the Refresh history dialog.
However, In Power BI, gateway is the only way you'll be able to automatically refresh power bi reports when published to the server.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |