Forum Discussion

Nile's avatar
Nile
New Member
3 years ago
Solved

Published report when refreshed shows date and data for December 2023

Hi all, I have developed a sales report.  The pbix file shows correct dates and data (current data i.e. May 2023) even when refreshed on pbix file, however when I publish and it get refreshed the rep...
Need Help
  • StefanoGrimaldi's avatar
    StefanoGrimaldi
    3 years ago

    in the power bi desktop file go to power query and make a step on the column data to data type "locale" select date, and specify the regional or country base date formate you want, this will avoid that if your pbix file and service service suspcroption are on a different region this will ensure to maintain the data or hour intigrity between them. 

     

    hope this helps. 

  • Nile's avatar
    Nile
    3 years ago

    Thanks Stefano, but how do I implement it.

    Thanks Nile

  • Nile's avatar
    Nile
    3 years ago

    Implemented and solved.  Thanks 

StefanoGrimaldi's avatar
StefanoGrimaldi
Resident Rockstar
3 years ago

in the power bi desktop file go to power query and make a step on the column data to data type "locale" select date, and specify the regional or country base date formate you want, this will avoid that if your pbix file and service service suspcroption are on a different region this will ensure to maintain the data or hour intigrity between them. 

 

hope this helps. 

Nile's avatar
Nile
New Member
3 years ago

Thanks Stefano, but how do I implement it.

Thanks Nile