Refresh Power Bi dataset based on API call

[Josef_A]

Looking for a simpler way to refresh the dataset than creating a service principal and granting it permissions & access, since our organizations has a lot of restrictions. 
So when data is loaded into DWH I can add POST request, to PowerBI service that refreshes the dataset. Is this possible?

BR
/Joe 

[Anonymous]

Hi @Josef_A ,

Thank you for your replies @Ashish_Goel_  @NandanHegde  @SaiTejaTalasila !

Were these two answers helpful to you in the latest replies?

Please accept the responses that address your questions as solutions, it will be a great help to others who have the same questions as you.

If you have any further questions, please feel free to contact me.

Best Regards,
Yang
Community Support Team

[Ashish_Goel_]

Hi Josef,

You can use power automate to refresh the dataset. You can visit the link below:

https://ashishcoder.com/courses/power-bi/power-bi-service/refresh-power-bi-dataset-using-power-autom...

Thanks,
Ashish

[SaiTejaTalasila]

Hi @Josef_A ,

You can use power automate.If you were able to generate a email once your ETL is completed on DW then you will able to achieve it.

Even you can use ADF pipeline.

I hope it will be helpful.

Thanks,

Sai Teja 

Thanks,

Sai Teja 

[NandanHegde]

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:

https://datasharkx.wordpress.com/2022/11/05/refresh-power-bi-dataflow-dataset-from-azure-data-factor...

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 :

https://datasharkx.wordpress.com/2022/11/29/event-trigger-power-bi-dataset-dataflow-refresh-via-azur...

[Josef_A]

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..