Forum Discussion

shivprasads's avatar
shivprasads
Frequent Visitor
9 years ago
Solved

Direct Query take a long time to show updated data

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 t...
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    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

ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

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's avatar
    shivprasads
    Frequent Visitor
    9 years ago

    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