Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
We are also experiencing the same issue and when using the ‘is not (blank)’ and ‘is (blank)’.
Facing the same issue. Need to pass null value in an array but doesn't work anymore. It was working till Friday.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |