Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi, I have a Power BI Report with the following data (with scheduled refresh frequency of every 4 hours):
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
Solved! Go to 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:
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.
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:
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.