Forum Discussion

ShaWo's avatar
ShaWo
Icon for Advocate I rankAdvocate I
7 years ago

Daily dataset refresh not working after sundays

We have a report that is in mixed mode having couple tables in dual mode, couple in directquery and several others in import. 1. I create couple aggregate tables for different granuality levels to s...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi ShaWo 

I cannot reproduce the same issue.I would suggest you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Regards,

ShaWo's avatar
ShaWo
Icon for Advocate I rankAdvocate I
7 years ago

Thanks, I've done this and have been in talks with the support for couple weeks now. Just wondering if anybody else have seen this kind of behaviour in their models.

  • dkangel21's avatar
    dkangel21
    Frequent Visitor
    6 years ago

    Any solution to this?  I found out today we are having the same issue.  In service (not desktop) the dual mode doesn't always refresh properly.

    • ShaWo's avatar
      ShaWo
      Icon for Advocate I rankAdvocate I
      6 years ago

      Unfortunately we didn't really resolve this issue by fixing the afformentioned reports. We managed to get around the issua by going to full import mode and creating views for the data to be imported. The model still has calendars that are calculated on the fly and everything is working just fine.

      We tried resolving the issue with microsoft support, but that wasn't really helpfull. Their suggestion was to create the views for the dataset, but if the model was on mixed mode the model just wasn't refreshing after sunday even with views. They dug up some statistics that some of the queries might be heavy so that it might be that reason. For me that sounds as a weird reason as that would mean the model wouldn't update any other day too.

      Hopefully they find a proper reason for this as the mixed mode models are really useful. In our case the model reads about 5 million rows for two tables 8 times a day when it actually wouldn't need to download so many rows for the data to be up to date.

       

      dkangel21 If you get microsoft support to help you or find a solution, please update here. I'm very keen on learning what is happening with the mixed mode models even though there isn't any issues currently.