Forum Discussion
Date formatting error when using a PowerBI dataset in Excel
Hello, I uploaded a dataset to PowerBI Web from Excel, it shows as a a proper dataset when viewed online: When connecting to it from PowerBI Desktop, the dates are all in the Date forma...
Hi!
I checked and the dates are all in the correct format in the Power Query editor of Power BI. I even tried using the datetimezone format, but still no luck:
Hi Spigaw ,
I have a found a solution where you have to mark date column as 'Date' Table. Then it appers as date in excel.You can also refer this- https://community.fabric.microsoft.com/t5/Service/Analyze-in-Excel-feature-Date-are-not-recognized-in-Excel-file/m-p/1551413#:~:text=The%20trick%20was%20to%20%22mark,it%20then%20appeared%20in%20Excel%20!
Thanks for the link! I will give it a try this week and reach back to tell you if it worked