Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

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, t...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

    Works perfectly. Thank you so so so much