locked
Unable to add Timeline in PowerPivot RRS feed

  • Question

  • Hi All,

    I have deployed one Data Model to SharePoint 2013 & I am generating some reports out of it. Using PowerPivot Linked Data as a connection. I have Date fields inside Model.

    So when I am trying to insert timeline in new report I am getting an error as " We can't create a Timeline for this report because it doesn't have field formatted as Date".

    when I add Timeline in Data Model's excel file sheet it is allowing me to insert Timeline, but not allowing in newly created reports using that shared Data Model.

    Thanks in advance!

    Monday, January 27, 2014 8:38 AM

Answers

  • " We can't create a Timeline for this report because it doesn't have field formatted as Date".

    If you are getting this error message, there is a good chance you don't have the original source date table marked as a date table.

    It sounds like you have created a Power Pivot workbook and uploaded it to SharePoint.

    Then I assume you created a BI Semantic Model (bism) connection to the workbook in SharePoint.

    Now you are using the bism connection as an SSAS/Power Pivot data source for a new excel file.

    If the date table in the original Power Pivot model that you uploaded is marked as a date table and the unique date field is marked as the date table's "key", then timeline slicers should work fine for your new excel file.

    To mark the original date table as a date table, go into the original model, go to the date table, in the Power Pivot window go to the "Design" tab in the ribbon and you should see a button for "Mark as Date Table".

    Then reload this original model to SharePoint and you should be all set.

    Anytime you have a Date Table or dimension in Power Pivot or SSAS Tabular, you should mark it as such like this.  It doesn't always make a difference depending on what you are doing but certain Time Intelligence functions won't work properly without it.  It's easy to forget sometimes and I have done it plenty myself.

    Thursday, May 15, 2014 9:35 PM
    Answerer

All replies

  • By using the  following way I am generating reports from shared Data Model which is deployed on SharePoint-2013 using Power Pivot Gallery.
    Monday, January 27, 2014 12:15 PM
  • Hello,

    Have you defined the column as data type = "Date"?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, January 27, 2014 12:29 PM
  • Hi Olaf,

    Yes it is done! That's why I am able to insert Timeline in shared Data Model's Excel file/sheet.

    But when I am creating reports using that shared model (as Power-Pivot Linked Data) in that report I am unable to insert Timeline. 

    As I told earlier how I am generating new reports using shared Data Model ( in earlier Post/image).

    or may we can't insert Timeline in Power-Pivot Linked Data's sheet??

    Shared Model Excel                      (Can Insert Timeline)

             ||

     New Report(using above)           (Can't Insert Timeline)

    FYI. In these newly created reports the Model is empty as it is linked to shared model. so there is no way to set type of column to 'Date'.

    Monday, January 27, 2014 1:43 PM
  • Hi Olaf,

    Did you get my question or not?

    I have done some investigation on it & came across some conclusion.

    Let me tell you, I think it's not possible to add Timeline in PP Linked Data sheet.

    This is because when we use PP Linked Data as a data source, our current sheet's model left empty & while using Pivot field list it consider all fields as General data-type only.

    So we don't have any option to set data-type of field & that's why its NOT Possible.



    Wednesday, January 29, 2014 5:50 AM
  • I don't have Sharepoint 2013, so I can't test it to give you further assistance.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, January 29, 2014 6:34 AM
  • Oh I see!

    anyways Thanks Olaf.

    Wednesday, January 29, 2014 7:21 AM
  • Hi Olaf,

    Can you please check it on SharePoint 2010?

    Wednesday, January 29, 2014 7:59 AM
  • I don't have any Sharepoint available here.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, January 29, 2014 8:16 AM
  • Rameshwar, is this still an issue?

    Thanks


    Ed Price, Power BI & SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Thursday, April 24, 2014 5:28 AM
  • " We can't create a Timeline for this report because it doesn't have field formatted as Date".

    If you are getting this error message, there is a good chance you don't have the original source date table marked as a date table.

    It sounds like you have created a Power Pivot workbook and uploaded it to SharePoint.

    Then I assume you created a BI Semantic Model (bism) connection to the workbook in SharePoint.

    Now you are using the bism connection as an SSAS/Power Pivot data source for a new excel file.

    If the date table in the original Power Pivot model that you uploaded is marked as a date table and the unique date field is marked as the date table's "key", then timeline slicers should work fine for your new excel file.

    To mark the original date table as a date table, go into the original model, go to the date table, in the Power Pivot window go to the "Design" tab in the ribbon and you should see a button for "Mark as Date Table".

    Then reload this original model to SharePoint and you should be all set.

    Anytime you have a Date Table or dimension in Power Pivot or SSAS Tabular, you should mark it as such like this.  It doesn't always make a difference depending on what you are doing but certain Time Intelligence functions won't work properly without it.  It's easy to forget sometimes and I have done it plenty myself.

    Thursday, May 15, 2014 9:35 PM
    Answerer
  • Think I've solved this. 

    Had the same problem and found my data had blanks or similar for some dates.  By replacing these dates with zero, it asumes the date is 00/01/1900.  This then worked.  Note that the format needs to be date format too.

    Good luck

    Alan

    Thursday, October 5, 2017 9:16 AM
  • There are 2 options :

    • Column/Attribut with Data Type = Date 
    • Time Dimension : Mark as Date Table

    More information : http://www.concatskills.com/2018/02/04/we-cant-create-timeline-because-report-doesnt-have-field-formatted-as-date/


    Sunday, February 4, 2018 6:58 PM