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

[hellgoingon]

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?

[Eric_Zhang · Accepted solution]

---

@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.

[hellgoingon]

Yes! Thanks