I don't have much expertise in Power BI. I started work on it and found it very easy and I've created a report. That report is working fine.
Now, I've requirements to add Refresh button on the report that will refresh the data source and get the latest data from it. I tried to search alots on it but still, I'm not able to find any reasonable solution.
Do we have that kind of functionality available on Power BI?
Thank you for your time!
Assuming you are working on powerbi.com, the end user cannot refresh the data in a report manually (though it is possible to manually refresh a dataset in a workspace if you have permissions to the workspace and have a data gateway set up).
You can either set up a refresh schedule or else build your report using a DirectQuery which will always use the current data.
You can embed a PowerApp that calls a FLOW that calls the Power BI API to trigger a manual refresh. I found this posting very helpful in setting it up: Article by Konstantinos Ioannou
I chose a direct query for retrieving the updated data into the PowerBI report.You can set the refresh rate in dataset settings.I did set it to 15 mins. After 15 mins it was refreshing in Power bi workspace online.But the embedded report deployed on the website was refreshing within an hour.I think there is no way to manually refresh the embedded report instantly.It automatically refreshes within an hour. As for the report in Power bi workspace, it can be manually refreshed instantly by checking dataset settings-> refresh now.
