Direct Query take a long time to show updated data

[shivprasads]

I have created a Direct Query report which is collected to the live database.

Once I change something in the database, the dataset needs to be refreshed manually or need to wait for a while before the scheduled refresh takes place.

Once the refresh is done, the report section in the portal shows up the latest data but the embed link created still shows the old data and takes around 15 mins more to update.

The data being drawn belongs to a single table and contains not more than 400 records,  if that help.

I need to understand if I am missing out on something or this is the way it should be working.

[v-haibl-msft · Accepted solution]

@shivprasads

It should be a normal situation. In this official document, there are some notice points as below.

After you create your Publish to web embed code and share it, the report is updated with any changes you make. However, it’s important to know that it can take a while for update to be visible to your users. Updates to a report or visual take approximately one hour to be reflected in Publish to web embed codes.

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.

Best Regards,

Herbert

[shivprasads]

Thanks a lot for the citation.

[ankitpatira]

@shivprasads Fact that you're seeing new data in portal straight away means there is nothing broken and it works. By embed link do you mean Publish to Web if yes then it should work as well with DQ and not wait till 15 minutes.

[shivprasads]

Thanks  @ankitpatira for the  response.

The new data is seen on the portal only once a scheduled refresh is done(which generally happens with an interval of 10-15 mins) or requires to explicitly refresh the dataset - is this how it should work?

Yes, by embed link I do mean the publish to web link. once the new data is seen on portal, it takes 15 more mins to be visible on the reports of those links.

Regards,

ShivprasadS