Forum Discussion

Eric's avatar
Eric
Icon for Advocate I rankAdvocate I
8 years ago
Solved

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 t...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    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,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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,

Wil's avatar
Wil
Regular Visitor
8 years ago

Hi Simon,

Is this problem going to be fixed?

 

Is there any workaround?

 

Thanks