Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper II
Helper II

Date formatting error when using a PowerBI dataset in Excel



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 format:





However, when connecting to it from Excel, the dates are considered in a General format, and are unusable:



Is there any way to force Excel to display the dates in the correct Date format?


Please note that every service and app I use (PBI Web, PBI Desktop, Excel) are localised in French.


The same goes for all the data of my dataset; I can't use any of the numbers as values. Everything is considered as text / General format.


Thanks in advance for any help.




Helper II
Helper II

I tried three differents methods of uploading the dataset:

  • From PowerBI Desktop
  • The two methods in Excel:



Still no way to get the correct data format.


Frequent Visitor

Hi @Spigaw ,

Can you please verfy if date are in correct format in power query? 


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

Thanks for the link! I will give it a try this week and reach back to tell you if it worked

Helper II
Helper II

I tried using the dataset with Excel online. For some reason, I was able to aggregate numbers. I saved the file, but when I resume editing in Excel desktop, nothing can be edited (it even stops me from removing the pivot table fields).


I'm clueless.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors