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.
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.
Solved! Go to 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
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/
All the best,
Tom
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Hi @Akhil_1411 ,
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
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,
Happy to help!
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 |
---|---|
56 | |
19 | |
18 | |
18 | |
9 |