Forum Discussion

hellgoingon's avatar
hellgoingon
Helper II
9 years ago
Solved

Problem with data refresh in table when there are 2 tables in report with filter

Hi,

In my reports, i have 2 tables control (Table A and Table B) which contain 2 different datasets. There are also some filter control for each datasets.

Step1: When i choose filters for Table A, Data in Table A is updated base on chosen-filters
Step2: When i choose filters for Table B, data in Table B is updated base on chosen-filters -> BUT data in Table A is refresh without any chosen-filter, it display all data.

Question is: What can i do so data in TableA is not affected when choosing filters for TableB?

Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago
    hellgoingon wrote:

    Hi,

    In my reports, i have 2 tables control (Table A and Table B) which contain 2 different datasets. There are also some filter control for each datasets.

    Step1: When i choose filters for Table A, Data in Table A is updated base on chosen-filters
    Step2: When i choose filters for Table B, data in Table B is updated base on chosen-filters -> BUT data in Table A is refresh without any chosen-filter, it display all data.

    Question is: What can i do so data in TableA is not affected when choosing filters for TableB?

    hellgoingon

    Are you looking for the option "Include in report refresh"? By the way, this option only effect in Power BI desktop. After published to Power BI Service, all queries refresh.

2 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago
    hellgoingon wrote:

    Hi,

    In my reports, i have 2 tables control (Table A and Table B) which contain 2 different datasets. There are also some filter control for each datasets.

    Step1: When i choose filters for Table A, Data in Table A is updated base on chosen-filters
    Step2: When i choose filters for Table B, data in Table B is updated base on chosen-filters -> BUT data in Table A is refresh without any chosen-filter, it display all data.

    Question is: What can i do so data in TableA is not affected when choosing filters for TableB?

    hellgoingon

    Are you looking for the option "Include in report refresh"? By the way, this option only effect in Power BI desktop. After published to Power BI Service, all queries refresh.