Forum Discussion
Refresh Power Bi dataset based on API call
There is no need of Service principal, as long as you can leverage managed identity of the Azure offerings.
The below blog provides details to trigger Power BI refersh via ADF through managed identity:
when you say DWH, is it Azure Synapse or normal database you terming as warehouse?
In case if it is Azure SQL database, you can trigger based on the below flow of Azure SQL DB<> API integration :
Hi Sir,
Appreciate you taking the time to answer. In the first provided link however actually, he is using a service principal. Regardsless I'm searching for something much simpler. Like a simple API call that sends a POST to PBI with some authentication, and that's it. No assigning access rights for some service that then needs to be admin in workspace and what not.
We are using Oracle autonomous database as datawarehouse (DWH). I really wan't to just skip this and use automatic refresh, but I need the logic to be in place so it's easier managing loading of multiple semantic models in the future.
We got it to work with a powershell script, one possibility could be to trigger that powershell script, after data has been loaded? Using a Oracle Data Integrator..
