Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Nile
New Member

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 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. 

  • I checked the date table as date table and the column of date as date.
  • I have checked the date in the facts table that if is formated as date.
Snip from PBIX file - which is correctNile_0-1684640619690.png

 

Snip from publised reportNile_0-1684649856637.png

 


 

 

A diagnostic from the above for MTD is below:

 

Nile_1-1684649921551.png

 

3 ACCEPTED SOLUTIONS
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

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. 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




View solution in original post

Thanks Stefano, but how do I implement it.

Thanks Nile

View solution in original post

Nile
New Member

Implemented and solved.  Thanks 

View solution in original post

4 REPLIES 4
Nile
New Member

Implemented and solved.  Thanks 

Nile
New Member

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

 

StefanoGrimaldi
Resident Rockstar
Resident Rockstar

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. 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




Thanks Stefano, but how do I implement it.

Thanks Nile

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors