Automatic Visual Refresh after Flow Completes

[dwelsh]

I have a Microsoft Power Automate Flow button on my Power BI report that refreshes the dataset. Flow completes successfully, but the visuals on the page do no update unless the Refresh visuals button is pressed. Is there a way to make the visuals automatically update after Flow completes?

[marcelsmaglhaes]

Hey @dwelsh ,

Maybe this article can help: Trigger a cloud flow from any Power BI report - Power Automate | Microsoft Learn

Kind Regards,
Marcel

[dwelsh]

Thanks Marcel. I have created a Power Automate button to refresh the dataset but it doesn't refresh any of my visuals with the new data unless I select the refresh visuals button. Is there a way to refresh visuals as part of the Power Automate process?

[marcelsmaglhaes]

Hey @dwelsh ,

Take a look in this link: Automatic page refresh in Power BI Desktop - Power BI | Microsoft Learn

Regards,
Marcel

[dwelsh]

Thanks for sharing the link. It looks like it is not supported with datasets using Import. 

[marcelsmaglhaes]

Oh, I see. I was working in another similar question that uses DirectQuery and I confused.

I have some automatic datasets update using Power Automate. When the Flow is updated, automatically updates dataset and reports. 

Take a look in this link: Refresh your Power BI dataset using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI

I believe is that your needs. Let me konw if helps.

[dwelsh]

The Dataset Refresh Flow is triggered by a button within my Power BI report. The flow completes successfully, however even though the dataset is updated, the visuals still have outdated data until I press the PBIs built in Refresh Visual button referenced in the screenshot in my intial post. Is this because I am using Import mode instead of Direct Query? Is it not possible to do this with Import mode?