Forum Discussion

m_j_holland's avatar
m_j_holland
Regular Visitor
2 years ago

Data Sync by Date is Off after Refresh

Hi,   I'm having some issues with my data not showing on the correct date in the Power BI Service.   Below is data from Meta for a Campaign, by Day. It shows the correct information.     ...
Need Help
Show and Tell
m_j_holland's avatar
m_j_holland
Regular Visitor
2 years ago

Hi,

 

It's saying North Central US (Illinois). But if this is the case, why would some dates be correct but others be off?

 

Are you also suggesting that I should set my sync times to line up with Illinois?

 

Mark

aj1973's avatar
aj1973
Community Champion
2 years ago

No but you can adjust the time zone here

 

Just out of curiosity, why using Illinois storage while you are in Australia? are you in free license?

  • m_j_holland's avatar
    m_j_holland
    Regular Visitor
    2 years ago

    So that is how I've got things set up - we refresh based on Sydney time, while our Global Service Account is managed out of the US (where head office is).

     

    So given I already have this set up in place, what else could be causing some days to refresh out of sync?

    • aj1973's avatar
      aj1973
      Community Champion
      2 years ago

      Do the test then keep troubleshooting if necessary

       

      • m_j_holland's avatar
        m_j_holland
        Regular Visitor
        2 years ago

        I'm not quite following. I've already shown that I'm set up to refresh in Sydney, but that for some of the most recent dates, the data is out of sync with the database, but then it resolves itself towards the end of my incremental refresh.

         

        What are you suggesting I try?