How to apply auto refresh report data after publish ?

[rakesh_singh]

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. 

[Anonymous]

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.

[rakesh_singh]

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.

[Seth_C_Bauer]

@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.

[rakesh_singh]

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. 

[v-shex-msft]

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

On-premises data gateway

Regards,

Xiaoxin Sheng

[rakesh_singh]

Hello,

I have installed on premise gateway on my system and also configured as per suggested through URL's.

I have set the scheduled refresh for report/dataset for the time 14:00 and then scheduled is started on time and take 3-10 min to complete it.

After scheduling process is completed then i have refresh the publish URL which is using in MVC application but not showing refreshed data.

So please provide the some video or tutorial on it so can understand it scheduled refresh process.

Thanks 

Rakesh Singh

[v-shex-msft]

Hi @rakesh_singh,

It seems like you use the publish to web function to embed your report in your web application, right?
If this is a case, publish to web has one hour delay after the source data refresh.

For detail information, you can refer to below link:

Publish to web from Power BI

Data refresh
Data refreshes are automatically reflected in your embedded report or visual. It can take approximately 1 hour for refreshed data to be visible from embed codes. You can disable automatic refresh by selecting do not refresh on the schedule for the dataset used by the report.

Regards,

Xiaoxin Shenge

[Anonymous]

Did you check the refresh history as I had indicated? Are there any errors?  Does the data refresh successfully on the desktop application?  If the data is not being updated on the desktop application, then the issue is not with scheduling.  If the data updates on your desktop and not in the cloud then look for error messages in the refresh history.