Power BI Different Refresh Timings

[xiuqinglim20]

Hi, I have a Power BI Report with the following data (with scheduled refresh frequency of every 4 hours):

• 3 Tables from SQL
• 1 Merged Table from above 3 Tables
• 1 Table from Sharepoint

I have a Power Apps embedded into the report where the user can input comments to be reflected in the report visuals. The Power Apps will update the Sharepoint Table (Point number 3 above) and I have a Power Automate that will trigger the refresh of the Power BI dataset. 

However, I do not want to refresh the entire dataset unnecessarily as the SQL tables & the merged table are large and would take a lot of time. I just want to refresh the Sharepoint table to reflect the comments input by user instead of waiting for the comments to be reflected at the next 4 hour mark. How can I do this?

I tried experimenting with dataflows but as I publish the Report to Service, it creates its own dataset automatically and refreshing the dataflow does not refresh this newly created dataset

[v-yangliu-msft · Accepted solution]

Hi  @xiuqinglim20 ,

It is recommended that you publish the report to the service, and then use the Power Apps visual as a tile pin to the dashboard, and then use PowerAutomate to achieve a higher frequency scheduled refresh of the report to achieve a similar effect.

Refer to:

Schedule Refresh Power BI dataset with Power Automate! | by Nimai Ahluwalia | All About Power BI | M...

Best Regards,

Liu Yang

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