Forum Discussion
GouthamPamula
3 years agoNew Member
apply filters to power bi report using power bi javascript api
I'm applying custom filters for power bi report using some javascript code. but filters are not applying . Im getting powerbi report on browser without any filter. I'm following Javascript code he...
- Anonymous3 years ago
Hi GouthamPamula ,
You can refer the following links to get it:
Addling filter using javascript API (Power BI Service)
Embed your Power BI report with predefined filters
const filter = { $schema: "http://powerbi.com/product/schema#basic", target: { table: "DimProduct", column: "ColorName" }, operator: "In", values: ["Silver"] }; var config = { type: 'report', tokenType: models.TokenType.Embed, accessToken: accessToken, embedUrl: embedUrl, id: embedReportId, permissions: models.Permissions.All, settings: { filterPaneEnabled: true, navContentPaneEnabled: true } }; // Embed the report and display it within the div container. var report = powerbi.embed(reportContainer, config); report.on('loaded', event => { report.getFilters() .then(filters => { filters.push(filter); return report.setFilters(filters); });Best Regards
Anonymous
3 years agoNot applicable
Hi GouthamPamula ,
You can refer the following links to get it:
Addling filter using javascript API (Power BI Service)
Embed your Power BI report with predefined filters
const filter = {
$schema: "http://powerbi.com/product/schema#basic",
target: {
table: "DimProduct",
column: "ColorName"
},
operator: "In",
values: ["Silver"]
};
var config = {
type: 'report',
tokenType: models.TokenType.Embed,
accessToken: accessToken,
embedUrl: embedUrl,
id: embedReportId,
permissions: models.Permissions.All,
settings: {
filterPaneEnabled: true,
navContentPaneEnabled: true
}
};
// Embed the report and display it within the div container.
var report = powerbi.embed(reportContainer, config);
report.on('loaded', event => {
report.getFilters()
.then(filters => {
filters.push(filter);
return report.setFilters(filters);
});
Best Regards
- GouthamPamula3 years agoNew Member
Thank you for sharing the information