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...
  • 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.