Forum Discussion
How to apply auto refresh report data after publish ?
I am facing issue to auto refresh report. I have created a sample report in power BI desktop tool and data source is SQL Database. Now i want to auto refresh report data when new data is inserted in datasource which i was used in report.
I have also read a artical on scheduled Refresh feature which is using through gateway and i have also installed personal gateway on my system and i have set the scheduled refresh on newly created report after publish through app.powerbi.com link.
After scheduled refresh is over my report is not show the new inserted data and after some time (30 Min Approx) report is refresh.
Please suggest on auto refresh.
8 Replies
rakesh_singh Depending on your use case, it sounds like Direct Query may be an option. This would require installing the On Premises Data Gateway. This would allow you to interact with the report at any time and see the latest information. If you are not familiar with the connection types I wrote a blog here that explains them.
If you expect the report to just automatically refresh without interaction, it currently doesn't work like that.
I am new in Power BI desktop so i know there is a option of Direct Query when we connect to datasource. But my question is how do i use this option.
It would be much better if you can provide som tutorial on DQ and also how to use On Premises Data Gateway to refresh my publish report.
Hi rakesh_singh,
If you want to know more about how to use on premise gateway to refresh report, you can refer to following links:
Manage your data source - SQL Server
Regards,
Xiaoxin Sheng
Rakesh,
I have an on premise gateway, but the following suggestion probably still applies.
1) Do a manual refresh by clicking on the elipses next to the dataset and choose "Refresh Now". If this completes successfully but the data is not updated then most likely the issue is not with scheduling.
2) Check your refresh history to see if they are getting executed. You will have an error message if they are not. You can access this info by selecting settings (under gear box) -> datasets -> refresh history. If the status is completed, then I would double check the SQL Query again :)
I hope this helps you isolate the problem.
This is anonther way to refresh mr created report. But I want refresh my publish respot when new data is inserted in table which im was used in POWER BI as datasource.
