Refresh data button

[StephenF]

I wish to have a button in my powerBI to refresh the data. This report is embedded in my sharepoint and changes need to be cascaded through from a powerapp that updates my SQl data source.

Is there a way to do this natively either through a button or have an autorefresh(say every ten minutes)?

I think i can scedule a data source to update up to 8 times a day so does that cascade straight through to a PBI visual or does the visual need to have the ability to refresh itself also?

[parry2k]

@StephenF is not a hack, it is a proper solution and no page shows up, not sure where you read that. I use it all the time.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[StephenF]

Ok when the data refreshes in the data set does it cascade through to a powerBI embed on a sharepoint page then? Is there a guide?

[v-rzhou-msft · Accepted solution]

Hi @StephenF 

What kind of connection mode did you use to connect to SQL, import or  directquery?

If you use import connection mode and you have pro license, you can install a gateway and configure schedule refresh(8 times per day).

If you have premium license, your can set schedule refresh 48 times per day.

If you use direct query mode to build your report, you can set your schedule cache refresh interval to 15 minutes .

I think you may use embed to sharepoint function to embed your report to your sharepoint site.

Your embed report will refresh automaticlly after you refresh your browser.

Refresh succeed:

Result is as below.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[parry2k]

@StephenF you can use Power Automate to refresh the power BI dataset, you can schedule how often you want to refresh. Keep in mind, under Power BI pro you can refresh only 8 times a day.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[StephenF]

Is this the hackish workaround i saw online that involves a html page popping up or is it seamless?