Timeline filter is removed from Excel Sheet after updating data in Excel using SSIS

Poornima 21 Reputation points
2021-11-26T12:59:14.067+00:00

I have an excel file (.xlsx) with 2 sheets summary and detail. The summary sheet has 2 slicers, 1 pivot table , 1 chart and a timeline filter control.

The summary sheet is updated based on detail sheet data.

I am updating detail sheet data using SSIS. After SSIS package runs successfully if I open the excel then I am not able to see the timeline control. Getting below error while opening the excel.

152869-image.png

Error:
152879-image.png

The objective is to use automate the update in detail sheet data rows.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,618 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Emily Hua-MSFT 27,466 Reputation points
    2021-11-29T09:09:23.237+00:00

    Hi @Poornima

    Do you mean your data for Timeline filte is sourced from 2 Excel worksheers?

    • From the perspective of Excel, it is recommended to check the date format. As I do not have the environment with SSIS, I could not do the tests for your, if there is any settings related to date dimension, I suggest you check whether you have set it correctly.
      We need to avoid removing the timeline because Excel cannot recognize the date field.
    • Please also ensure there are no blanks in your column of dates.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


    0 comments No comments

  2. Poornima 21 Reputation points
    2021-11-29T09:09:59.507+00:00

    The excel is working fine if we manually delete the rows in detail sheet. The issue occurs when writing the details sheet in ssis.

    0 comments No comments

  3. Olaf Helper 39,181 Reputation points
    2021-11-29T09:14:12.113+00:00

    The SSIS Excel Destination is very limited and supports only some Excel features and such issues can happen, see Import data from Excel or export data to Excel with SQL Server Integration Services (SSIS)

    0 comments No comments