PBI to Excel: using the semantic model "can't create a timeline"

[Anonymous]

Hi everyone,

I have an issue on MS Excel when I connect an Excel spreadsheet to a semantic model.

I used two ways:

• from PBI online, using the function "Analyze in Excel", report created online, then opened in the desktop app.
• from a new Excel file, using "From Power platform/From Power BI"

In both case, I am not able to create a timeline. 

In the semantic model, the date is properly formatted as Date.

I checked a lot of discution even from 2017... But I didn't find a fix.

Can you help me on that.

Seb

[Anonymous · Accepted solution]

Hi @Anonymous 

I tried a solution from the following old thread. It works for me. Analyze in excel insert timeline error - Microsoft Fabric Community

Mark the table as date table. Then publish the pbix file to the service to replace the old semantic model. 

Then I'm able to select the date column for a timeline slicer. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[Anonymous]

Works perfectly. Thank you so so so much