Forum Discussion
Data update via web UI
Hi folks,
I built a report/dashboard in Power BI desktop and published it to the web. The report is linked to an Azure database. I shared the report to end-users who access via the web. After the dataset has been updated, I would like end-users to be able to refresh via the Power BI web UI and see the report with the updated data. I have tried as an end-user and I can update the data set as well as import data, but unfortunately the old report remains. If I update via my own Power BI desktop and publish again, then the updated report becomes available to end-users, but that is not a sustainable method. What is the proper way to deal with this situation? I would greatly appreciate any help! Many thanks in advance...
8 Replies
SoulCuber The report creator (you) owns the refreshing of a report. You can schedule a refresh up to 8x per day for imported data. Otherwise you could use Direct Query, and this would show your end users the data in the database without the need for a refresh.
Hi SoulCuber,
As SoulCuber suggested, you can create schedule refresh in Power BI service if you connect to Azure SQL database in Import mode. See: Configuring scheduled refresh.
If it's DirectQuery mode, you can take a look at this article: Databases in the cloud.
Best Regards,
Qiuyun YuHi Anonymous and v-qiuyu-msft,
Many thanks for your help. It took me a while for testing your suggestions and I have been successful with the update via refresh as well as the scheduled update. Unfortunately, I was not able to set up a directquery. This seems a good solution for my situation. Is it possible to do this for an SQL database on Azure? Do I need a special setup for this? I would really appreciate your feedback. many thanks in advance...
SoulCuber To utilize direct query from Azure SQL DB - you can just connect to it in direct query mode from the desktop, create your reports and publish. When you use Azure SQL DB it doesn't require a gateway, so this should just automatically work.
Hi Anonymous,
Thanks for the response. I tried via desktop to change data source settings for the active database and unfortunately the directquery option is greyed out... Any ideas why?
