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.
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
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |