Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 ...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    2 years ago

    Anonymous 

    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.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

foodd's avatar
foodd
Community Champion
2 years ago

Hello Anonymous ,  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!