Solved: Re: Report Refresh only after Data loaded in Dataw...

powerbiexpert22 · ‎12-20-2023

I want to refresh power BI reports only once ETL jobs are completed and data is loaded on Datawarehouse , ETL job completion timing is not fixed, how to achieve it?

Data warehouse is bult on on premises Postgresql database

NandanHegde · ‎12-20-2023

Hey,

In any solution planned, the way would be to trigger the refersh of the PowerBi report via the REST PI method.

So the flow would be ETL jobs >> trigger REST API.

Below sample via ADF/Synapse :

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

----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

View solution in original post

Anonymous · ‎12-20-2023

Here is a link to a Talend Community question about refreshing a Power BI model

How to access Power BI Rest APIs through Talend using basic authentication?

View solution in original post

NandanHegde · ‎12-20-2023

Hey,

In any solution planned, the way would be to trigger the refersh of the PowerBi report via the REST PI method.

So the flow would be ETL jobs >> trigger REST API.

Below sample via ADF/Synapse :

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

----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

Anonymous · ‎12-20-2023

How are the ETL jobs run? SSIS? Azure Data Factory? Synapse pipelines? Other method?

powerbiexpert22 · ‎12-20-2023

Talend jobs

Anonymous · ‎12-20-2023

Here is a link to a Talend Community question about refreshing a Power BI model

How to access Power BI Rest APIs through Talend using basic authentication?

Greg_Deckler · ‎12-20-2023

@powerbiexpert22 Probably the best thing to do is to use Power Automate. Create a trigger on when the ETL jobs are complete with an action of refreshing the Power BI dataset.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...