Trigger the dataset refresh after Azure ETL process completes

[Akhil_1411]

Hi All,

I need your thoughts on, how i can configure to trigger the refreshes once my Azure ETL process completes.?

Is there any nice blog where i can see the steps and apply it?

My client is using premium workspace.

Thanks,

Akhil.

[tackytechtom]

Hi @Akhil_1411,

There is a way to use the Power BI API to refresh datasets from data factory without app registrations / service principles, logic apps etc. It works similarly to the app registration approach but it uses only managed identity.

I add some posts that show you how to refresh even specific tables or just partitions in a dataset from either an Azure Data Factory or an Azure Function:

https://www.tackytech.blog/how-to-refresh-power-bi-datasets-from-data-factory-with-managed-identity/

https://www.tackytech.blog/how-to-refresh-individual-tables-or-partitions-in-power-bi-dataset-from-d...

https://www.tackytech.blog/how-to-refresh-power-bi-datasets-tables-and-partitions-with-azure-functio...

All the best,

Tom

[v-luwang-msft]

Hi @Akhil_1411 ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.

Best Regards

Lucien

[v-luwang-msft · Accepted solution]

Hi @Akhil_1411 ,

The following article tells about data refresh and etl ,wish it is helpful for you!

Greater control of your Power BI Datasets with the Power BI REST API: https://altis.com.au/greater-control-of-your-power-bi-datasets-with-the-power-bi-rest-api/ 
How To Trigger A Power BI Dataset Refresh Using An Azure Data Factory Web Activity : https://www.moderndata.ai/2019/05/powerbi-dataset-refresh-using-adf  
Refresh Power BI Dataset from Azure Data Factory - Part 1 : https://www.mssqltips.com/sqlservertip/5976/refresh-power-bi-dataset-from-azure-data-factory--part-1 

Best Regards

Lucien

[ibarrau]

Hi. Sure you can. The question here would be, which is your Azure ETL Tool? it depends on that the tutorial we can send. The idea would be adding on that tool a new step after your ETL to refresh Power Bi Dataset throgh PBI Rest API.

I can give you an example of how to do it with azure data factory, but again I don't know your ETL tool and you should add it there

https://blog.ladataweb.com.ar/post/642023841877671936/azuredatafactory-actualizar-powerbi-con

I hope this helps,

[Akhil_1411]

@ibarrau , Thanks for your reply. we are bascially using Azure SQL database.