Forum Discussion

rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Data disappears after each Incremental Refresh

Hello,

 

Since last week I am facing a very strange issue.

I have Incremental Refresh configured for most of the tables in my dataset and Scheduled Refresh has also been configured.

Now, whenever schedule refresh is completed the data vanishes completely. It is not necessary it vanishes everytime the schedule refresh is completed. Sometimes, we can see the data and sometimes we cannot.

However, when I try to refresh the same dataset in my Power BI Desktop, it fetches data everytime. There is no error or any warning.
I find it really strange because the data doesn't disappear everytime the refresh is completed.

 

Has anyone faced the issue or have known of it?
Any help would be appreciated.

 

Thanks in advance.

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi rajulshah 

    Refresh on Desktop is different from on PBI service. On desktop it will always refresh on the star and end date yoy have set. On service it will set these dated dynamically from the second refresh.

     

    Points to check

    • Take a count on each table and max of date, display it and check for 2-3 days
    • do you know when your tables get the data.
    • measures which might be breaking if data is not loaded properly

    Post a snapshot of the M query on all tables using IR

    • rajulshah's avatar
      rajulshah
      Icon for Resident Rockstar rankResident Rockstar
      5 years ago

      Hello Anonymous,

       

      Thank you for the response.

       

      Yes, I have checked all of that. The thing is that the raw data from some tables is disappearing, even when the table doesn't have Incremental Refresh configured.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi rajulshah ,

     

    The characteristic of incremental refresh is this, you can refer to: Refresh ranges of incremental refresh

     

    If the data you want does not want to be deleted, please reset the period of your data storage.

     

     

    Best Regards,

    Stephen Tao

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi rajulshah ,


    Could you tell me if your problem has been solved?
    If it is, kindly Accept it as the solution. More people will benefit from it.
    Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.


    Best Regards,
    Stephen Tao

    • rajulshah's avatar
      rajulshah
      Icon for Resident Rockstar rankResident Rockstar
      5 years ago

      Hello Anonymous ,

       

      Nope, it is still not resolved. We are fetching data from SQL and have configured Incremental Refresh as below:


      Unfortunately, I won't be able to share the pbix file. 
      But if you have any insights, please share.

       

      Thanks.