Forum Discussion

jneijssen's avatar
jneijssen
Frequent Visitor
6 years ago

PowerBI connection to Excel and Timeline usage: No Date Format available

Dear Forum,   I have created a PowerBI Report that is available via PowerBI Online. I have connected this Report to Excel via the PowerBI Plugin. I have formatted 2 columns in PowerBI as "Date" (fo...
Need Help
Tutorial Requests
v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi jneijssen ,

 

Please change data type in Power query editor and check again.

 

jneijssen's avatar
jneijssen
Frequent Visitor
6 years ago

Dear Frank,

 

Thank you very much for your attempt to help me. Unfortunately this is not the solution. In the PowerBI-Desktop-App I have formatted the field with dates as "Date". When using analyse in excel, this field is not recognised as such. When trying to insert a timeline in Excel, I get the message back that a "Date"-field is not recognised.

 

I habe tried all sorts of date settings in the PowerBI-App. Nothing helped so far.

 

Kind regards,

 

Jochem