Forum Discussion
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...
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.
Thanks Stefano, but how do I implement it.
Thanks Nile
Implemented and solved. Thanks
Stefano, what I mean is that, will I have to do it for each of the column in all the fact tables. I have 4 fact tables with no. of columns ranging between 4 to 12.
Thanks Nile