Forum Discussion

2ccccc's avatar
2ccccc
Frequent Visitor
7 years ago

Data doesn't get updated by direct query report

I have a report, data connection type is mixed(all tables is direct query except I create a data table by using DAX). Data is from my Azure SQL Database. After I finished it, I published it to my pub...
Need Help
venal's avatar
venal
Icon for Memorable Member rankMemorable Member
7 years ago

2ccccc 

If it is older version of Gateway, please upgrade to the new version.

Have you enabled the below Gateway Settings in Power BI Service.

Power BI Service >> Settings >> Manage Gateways

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    7 years ago
    Also remember that you have to interact with a report for the data to be refreshed.

    or you have to press the refresh button.

    Whilst there is a new feature for the reports to auto refresh if you are using Power BI Pro it only updates every 30 minutes.
    • 2ccccc's avatar
      2ccccc
      Frequent Visitor
      7 years ago

      GilbertQ Does data get update if I click the refresh button on the report? I thought the 'refresh' button on the report only refresh the visualation on the report which doesn't refresh my data. Anyway it works. Thanks for the advise. However when I interact with my report, my data doesn't get updated. Why this? Or which kind of interaction can refresh my data in this case?

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        7 years ago
        HI there

        Can you confirm that there is data being updated in the underlying Azure SQL DB?

        Also are there any filters on your page or visuals which could be limiting the data from being updated?