Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 reporting date (latest reporting date e.g. 19-05-2023) change to some December 2023 date and even data against it. Though, of course there is not data beyond May 2023.
Snip from PBIX file - which is correct |
|
Snip from publised report |
|
A diagnostic from the above for MTD is below:
Solved! Go to Solution.
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.
Proud to be a Super User!
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
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.
Proud to be a Super User!
Thanks Stefano, but how do I implement it.
Thanks Nile
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
10 | |
8 | |
6 | |
6 | |
6 |