Forum Discussion

pani_victoria's avatar
pani_victoria
Helper III
2 years ago
Solved

data loss at last date

Greetings colleagues!

I have a problem.

I use Report Server to publish reports.
One report retrieves data for the last 10 days using an SQL query
...
WHERE timestamp>=curdate() - interval 10 day
...
The dashboard shows the results as of the maximum date.
For example: data was loaded from July 5 to July 15, the dashboard shows data for July 15 with the ability to select another date in this period.

But when I save the dashboard on the report server and configure automatic updating, the dashboard refuses to be empty, as if there is no data for July 15th.

When we used the power bi cloud, there was no such problem.

Can someone tell me what's wrong and what solutions are there?

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, pani_victoria 

    You can find the following file in the log file and open it

    C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles

    This is what it looks like when you open it

    Then refresh in the report server to see if there are any errors or exceptions during the refresh process.

     

    Because the Power BI service is more functional than Report Server, Report Server may have some limitations in the case of a mix of multiple data sources. So you need to check the logs of the report server runtime and other logs to see if there are any error messages.

     

    How to Get Your Question Answered Quickly

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • ChrisMuthmann's avatar
    ChrisMuthmann
    Resolver II
    2 years ago

    Hi!

    Sorry, I've got only questions and no answers for you!

    • It looks like you are running a report against a mysql source. Correct?
    • The automatic updating was successful?
    • How are you filtering on the 15th of July? 
    • The data for the 14h of July are available in the report?
    • Maybe there is a time gap between report server and mysql source?

    Kind regards,

    Christoph

    • pani_victoria's avatar
      pani_victoria
      Helper III
      2 years ago

      Hi!

      * Yes, the report connects to multiple sources - MS SQL, MySQL (main source), xls
      * Automatic update is successful
      * The main table is filtered by date (in the sidebar filter Top N 1 by date)
      * Yes, there is data for the previous day
      * We also had this version, but the server and source dates are the same