Forum Discussion

tez's avatar
tez
Resolver I
6 years ago
Solved

DirectQuery - data missing on app.powerbi.com

I created a DirectQuery dashboard for timed data (helpdesk ticket number per hour, bar chart). Data is displayed correctly at Power BI Desktop. When I publish it to app.powerbi.com and connect it to my dataset, it´s still all ok.

But after a few hours update seems to go wrong: New data is about 50% too low in app.powerbi.com, while it is correct displaying at Power BI Desktop. Even if I do a manual refresh, it doesn´t get better.

Do you have an advice, how I can get a clue what goes wrong? Does anyone have an idea of what might be the cause?

Thanks,
Thomas.

Need Help
  • tez's avatar
    tez
    6 years ago

    I think I found the problem. I had a filter in the query:

     

    = Table.SelectRows(dbo_CAL_IncAndSr, each [Field0] = 0 or Date.IsInCurrentDay([Field1]) or Date.IsInPreviousNDays([Field1], 21) or Date.IsInCurrentDay([Field2]) or Date.IsInPreviousNDays([Field2], 21))

     

    As soon as I removed the filter, the update - until now - worked without any problems. Maybe this is also interesting for other users.

5 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi tez ,

     

    Do you mean view report or dashboard in Power BI Service, or use embedded / publish to web? Have you tried to refresh the visual of report as following?

     

     

    If you mean tile pinned in dashboard, have you tried to configure "scheduled cache refresh" to "every 15 minutes" in dataset setting?


    Best regards,

     

    • tez's avatar
      tez
      Resolver I
      6 years ago

      Hi,

       

      thank you for your reply. It is a report in Power BI Service. And yes, I tried to refresh. The dataset cache refresh is set to "every 15 minutes" from the beginning.

       

      Is there a possibility to get insights about the refresh mechanisms of this specific report in Power BI Service?

       

      Regards,

      Thomas.

      • v-lid-msft's avatar
        v-lid-msft
        Community Support
        6 years ago

        Hi tez ,

         

        Please refer to this document about  the scheduled cache refresh and Direct Query, are you using on-premises data gateway or connecting from power bi service directly? Does this report have a heavy load or the data source is busy? Could you estimate approximately How much time the report is behind of the real data?


        Best regards,