Forum Discussion

CosminDogaru's avatar
CosminDogaru
New Member
1 year ago

Power Automate Refresh not working properly

Hi Guys, 

Firstly, I have to say I am kind of new to the whole Power suite, so I might do some begginer mistakes. 

 

I have built a report form my work team, to schedule Work From Home Days. 

 

I also built a small form for them to modify the scheduling, that has a Power Automate flow behind to modify the data (excel). 

 

The flow ends with a refresh for teh Power BI dataset. 

 

What happens is that, after the flow runs, and the dataset is refresh by power automate, the change is not reflected in the visuals. I can see that the flow works, and the dataset is refreshed. I can see the refreshes done by api in the refresh history of the dataset, but the visuals update only if I refresh the dataset manually. 

Could anyone shed some light onto this? 

7 Replies

  • Hello CosminDogaru,

     

    You need to be sure in your power automate that workspace and dataset is correct. I think when you run refresh from power automate button it refresh probably another dataset.

    Kind Regards,
    Gökberk Uzuntaş

    📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

    🔗 Stay Connected:
    📘 Medium |
    📺 YouTube |
    💼 LinkedIn |
    📷 Instagram |
    🐦 X |
    👽 Reddit |
    🌐 Website |
    🎵 TikTok |

    • CosminDogaru's avatar
      CosminDogaru
      New Member

      HI There, 

       

      This doesn't seem to be the case. Just to be sure I just now removed the refersh action and added it again in the automate flow. 

      It is pointing to the correct dataset, I can even see the refresh being done by the power autmate api, it's just that the visual doesn't update. It does only if I refresh it manually

      I don't know if this is of any concern, but we are using MS Teams tab to run the report. 

       

      Thank you

      • uzuntasgokberk's avatar
        uzuntasgokberk
        Super User

        Hello CosminDogaru ,

        I hope you are checking in Power BI Service. Because if you click the button in Power BI Desktop, ın PBI Desktop visualization won't be changed. İt will be effected directly to Power BI Service dataset which you configure for Pautomate.

        Kind Regards,
        Gökberk Uzuntaş

        📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

        🔗 Stay Connected:
        📘 Medium |
        📺 YouTube |
        💼 LinkedIn |
        📷 Instagram |
        🐦 X |
        👽 Reddit |
        🌐 Website |
        🎵 TikTok |

  • Im facing the same issue, did you find a solution? I find it interesting that i get my data through a form and when a new response is entered, powerbi visuals refresh with the newest old response but the newest is nowhere to be found.