Forum Discussion

alks_skla_f's avatar
alks_skla_f
Helper II
1 year ago
Solved

Refresh PBI with Power Automate

Hello, I have two datasets. First dataset is from Big Query (import mode, not DirectQuery). Second dataset is located on Sharepoint site in excel format. I created a button. Button executes flow: ...
Need Help
  • jithin-mathew's avatar
    jithin-mathew
    1 year ago

    Hi alks_skla_f 

     

    In the refresh history can you also check under OneDrive tab also - believing the comments are getting saved to excel file in sharepoint.

     

    ✎ᝰ. ------------

    Jithin Mathew

    If this post helped, give it a kudos! 👍

    ✅ Mark as solution to help others find it faster.

    #MicrosoftFabricCommunity

jithin-mathew's avatar
jithin-mathew
Frequent Visitor
1 year ago

Hi alks_skla_f 

 

After submitting the canvas form the page usually won't refresh as it's own. But you can add page refresh from the page configurations of Power BI to be executed every 5 mins or so. Additionally, if your form is getting submitted to the SharePoint excel then it should be updated in a while (from settings look at the refresh history, under onedrive if the file is getting refreshed after you submit). If it is from big query, then after inserting the data to the bigquery, add a step in the flow to initiate the dataset refresh after a short period of the time then data should be available back to your dataset and visual.

 

✎ᝰ. ------------

Jithin Mathew

If this post helped, give it a kudos! 👍

✅ Mark as solution to help others find it faster.

#MicrosoftFabricCommunity