Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello everyone,
I am trying to set the filters on the visual while embedding it.
I am getting the following error.
Is there any workaround for this?
The embed code:
const filter = { $schema: "http://powerbi.com/product/schema#basic", target: { table: "Manufacturer", column: "Sample Data" }, operator: "In", values: ["Abbas"] }; var config = { type: 'visual', accessToken: accessTokenToUse, embedUrl: embedURLToUse, reportId: reportIdToUse, pageName: pageNameToUse, visualName: visualNameToUse }; var dashboard = powerbi.embed(visualDiv, config); dashboard.setFilters([filter]);
Solved! Go to Solution.
Hi @Anonymous,
I'm afraid setting filters while embedding visuals isn't available for now. Please refer to the source code of Powerbi.js. I would suggest you create an idea here.
Best Regards,
Dale
Hi
Recently I have come across that problem as well
Just found a solution. It is to change object <filters> and call method <reload> of Visual.
/** * Reloads embed using existing configuration. * E.g. For reports this effectively clears all filters and makes the first page active which simulates resetting a report back to loaded state. * * ```javascript * report.reload(); * ``` */ reload(): Promise<void>;
For example
const pbiService = new pbi.service.Service(pbi.factories.hpmFactory, pbi.factories.wpmpFactory, pbi.factories.routerFactory); const embeddedObj = <pbi.Visual>(pbiService.embed(embedContainer, embedObj.config as {})); // will update visual using new filters from newFiltersArr after 10 seconds setTimeout(() => { (embeddedObj.config as any).filters = newFiltersArr; embeddedObj.reload(); }, 10000);
Hi @Anonymous,
I'm afraid setting filters while embedding visuals isn't available for now. Please refer to the source code of Powerbi.js. I would suggest you create an idea here.
Best Regards,
Dale