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
Power_BEE_AYE
New Member

Date column shows incorrect format when loading data into Excel

Hello,

 

I am new to PowerBI so please be patient with me.

 

I recently discovered that I could load an excel worksheet into my powerBI desktop app then upload the Myworkspace at work. One Issue I have run into is that the date column, instead of displaying the date in the format of "mm/dd/yyyy", which is the original format in the excel file, it shows the date in the format of, say "Thursday, February 1, 2024". The odd thing is that under "Transform Data" tab in PowerBI, the date is displayed under a correct format.

 

I am suspecting that when I load data from PowerBI platform into excel, something is messed up. Not sure how I can provide an example since there is sensitive data in the company file.

 

Any thoughts?

 

 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

@Power_BEE_AYE 

I think it is just a problem with the selected format on the table itself.  If you go into the table view and select the date column you can see (and change) the formatting.

jdbuchanan71_0-1720622110509.png

 

View solution in original post

4 REPLIES 4
jdbuchanan71
Super User
Super User

@Power_BEE_AYE 

I think it is just a problem with the selected format on the table itself.  If you go into the table view and select the date column you can see (and change) the formatting.

jdbuchanan71_0-1720622110509.png

 

OMG thank you!

Power_BEE_AYE
New Member

Unfortunately, when I loaded the file myself into Powerbi and reloaded it back into excel using Blank Query, the date was shown correctly. So I do not know what to do now...

 

I loaded my the data through my company PowerBI Cloud so that is where I suspected the issue came from.

Hello @Power_BEE_AYE ,  so, if you are suggesting that you may have solved the issue, please mark your reply as "Accepted as Solution" so that others who search for such an issue can find it easier.

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.