Forum Discussion
Trigger the dataset refresh after Azure ETL process completes
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.
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-1Best Regards
Lucien
6 Replies
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-1Best Regards
Lucien
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,
ibarrau , Thanks for your reply. we are bascially using Azure SQL database.
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 RegardsLucienHi @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/
All the best,
Tom
