Filter Behavior When Data Is Absent in Power BI Reports to Be Embedded in one application

[Shanila_7856]

Hi Community,

I’m planning to embed multiple Power BI reports (e.g., A and B) into an application. One of the reports has a Zone field, while the other does not.

When I apply a Zone filter through the application, what will happen if the Zone field is not present in one of the reports?

Specifically:

• For the report that includes Zone data, the filter should work as expected.
• But what will happen when the Zone filter is applied to the report that doesn’t contain this field?
• Will the report without the Zone field show its default data, or will it return an empty result or error?

I would appreciate any insights or suggestions on how this will behave once the reports are embedded.

Thanks in advance,

Shanila 

Embed For Customer - All Pages Filter 

[v-shex-msft]

HI @Shanila_7856,

Did the not display issue only appear on the specific report? What type of datasources and connection mode these report used? Any advanced security settings applied on these report?

Please share some more detail information about this issue and they should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Shanila_7856]

I have two reports: Report A uses a database as its data source, and Report B uses Excel as its data source. No security is applied to either report. I created a new table similar to the Excel data of Report B and embedded both reports using the Power BI API. My client requires applying filters from the application side, not within the report. Therefore, I added the filter in the application, with the filter values taken from the database. However, when I applied the state code as a filter using the 'IN' operator in the code, Report B did not filter as expected.

[v-shex-msft]

HI @Shanila_7856,

What type of filter parameter are you used? current it not able to directly use it operate with list type values. I'd like to suggest you concatenate them to text value with comma as delimiter.

Regards,

Xiaoxin Sheng

[lbendlin]

maybe IFERROR can give you some flexibility there.