topic Set filters while embedding a visual in Developer

Set filters while embedding a visual

Anonymous — Fri, 20 Jul 2018 12:38:11 GMT

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]);

Re: Set filters while embedding a visual

v-jiascu-msft — Mon, 23 Jul 2018 07:38:54 GMT

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

Re: Set filters while embedding a visual

artemmuntianu — Tue, 24 Jul 2018 08:25:52 GMT

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);