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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Spigaw
Helper II
Helper II

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:

Spigaw_0-1684869572986.png

 

When connecting to it from PowerBI Desktop, the dates are all in the Date format:

Spigaw_1-1684869707591.png

Spigaw_3-1684869827545.png

 

 

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

Spigaw_2-1684869752607.png

 

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.

 

 

 

6 REPLIES 6
Spigaw
Helper II
Helper II

I tried three differents methods of uploading the dataset:

  • From PowerBI Desktop
  • The two methods in Excel:

Spigaw_0-1684992748252.png

 

Still no way to get the correct data format.

 

Deepak_
Helper I
Helper I

Hi @Spigaw ,

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

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:

 

Spigaw_0-1684938338585.png

 

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.

Deepak__0-1685018454513.png

You can also refer this- https://community.fabric.microsoft.com/t5/Service/Analyze-in-Excel-feature-Date-are-not-recognized-i...!

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

Spigaw
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

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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