Forum Discussion
Report Refresh only after Data loaded in Datawarehouse
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
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 :
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?
5 Replies
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.
Talend jobs
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?
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 :
