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
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

Hi m_j_holland 

I beleive the difference comes from the refresh time in Power BI service. What is the location of your Power bi storage in the service ?

 

 

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
    Icon for Community Champion rankCommunity 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
        Icon for Community Champion rankCommunity Champion
        2 years ago

        Do the test then keep troubleshooting if necessary