We are working with Power BI embedded reports in our angular application. We are passing few filters from the client-side to the Power BI service and one such filter has the value "null" which is supposed to match with our DB value. This was working as expected and from the past few days, we are facing this issue. Currently, the data is not being filtered.
Below is our code to push filters and to embed the report.
const firstFilter: pbi.models.IBasicFilter = {
$schema: "http://powerbi.com/product/schema#basic",
target: {
table: TableName,
column: "column1"
},
operator: "In",
values: [value],
filterType: 1, // pbi.models.FilterType.BasicFilter
displaySettings: {
isLockedInViewMode: true,
displayName: "firstFilter"
}
};
const secondFilter: pbi.models.IBasicFilter = {
$schema: "http://powerbi.com/product/schema#basic",
target: {
table: TableName,
column: "column2"
},
operator: "In",
values: [value],
filterType: 1, // pbi.models.FilterType.BasicFilter
displaySettings: {
isLockedInViewMode: true,
displayName: "secondFilter"
}
};
//default for all reports
filters.push(firstFilter);
filters.push(secondFilter);
return <pbi.IEmbedConfiguration>{
type: 'report',
id: data.reportId,
tokenType: pbi.models.TokenType.Embed,
accessToken: data.embedToken,
embedUrl: environment.embedUrl,
filters: filters,
settings: {
filterPaneEnabled: false,
navContentPaneEnabled: true,
localeSettings: null,
layoutType: layoutType,
customLayout: {
displayOption: pbi.models.DisplayOption.FitToWidth
}
}
};
}
If anyone knows this issue or faced the same then kindly advise.
