cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Eric Regular Visitor
Regular Visitor

Excel Connect to PowerBi Data Converts Dates to Text

I'm connecting to PowerBi data using the Analyze in Excel add-in but when I add Dates to a PivotTable they show up as text even though they are clearly defined as dates in PowerBi.  Anyone know how to overcome this issue?

 

I am not adding the data to the data model and I am not using PowerPivot.  I am simply connecting to the OLAP data using the PowerBi add-in for Excel.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

Re: Excel Connect to PowerBi Data Converts Dates to Text

@Eric

 

By default, all dates will be evaluated as text when "connect live" to OLAP data source. 

 

Are you connecting OLAP source with live connection from Power BI? Can you share some screenshots?

 

Regards,

3 REPLIES 3
Moderator v-sihou-msft
Moderator

Re: Excel Connect to PowerBi Data Converts Dates to Text

@Eric

 

By default, all dates will be evaluated as text when "connect live" to OLAP data source. 

 

Are you connecting OLAP source with live connection from Power BI? Can you share some screenshots?

 

Regards,

Highlighted
Eric Regular Visitor
Regular Visitor

Re: Excel Connect to PowerBi Data Converts Dates to Text

Simon, thanks for the response.  Yes, I am connecting live to the PowerBI service (OLAP) which dramatically streamlines my Excel models and makes them much more responsive than having huge datasets in the Excel data model. 

 

But, the date conversion issue is a real nuisance.  To me, it makes absolutely no sense for dates to be converted to text by default.  Can this be changed?  Is there a switch setting somewhere to override the default setting?

 

Best regards,

 

Eric

 

Wil Visitor
Visitor

Re: Excel Connect to PowerBi Data Converts Dates to Text

Hi Simon,

Untitled.png

Is this problem going to be fixed?

 

Is there any workaround?

 

Thanks

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 134 members 1,702 guests
Please welcome our newest community members: