Model Driven App - PowerBI - JSON Filter String

(0) Share

Report

Posted on by Infiltrate-Dave

Hi All,

I have embedded a PowerBI report onto a form and trying to get it to filter based on the record that is open in the form. I have managed to get the report in the form using the PowerBI control but unable to get it to filter using the static JSON string. I have used the following string:

[{\"$schema\":\"basic\",\"target\":{\"table\":\"tableschemaname\",\"column\":\"column\"},\"operator\":\"In\",\"values\":[$a],\"filterType\":1}]", "Alias": {"$a": "column"}}

The column being used is the record GUID.

Is this the correct way to do it or is my filter in the incorrect format?

Any help would be appreciated.

Dave

I have the same question (0)

All responses (1)

Answers (0)

Leah Ju Microsoft Employee on at

Like (0)

Report

Hi Dave,

Refer to the following json to check your format:

https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/embed-powerbi-report-in-system-form#embed-with-contextual-filtering

Also, checking the following two points:

1)Table and column need to exactly match the names in Power BI.

2)The filter alias is the unique name from Dynamics 365 that you filter on.

In the following example:

<PowerBIFilter>

{"Filter": "[{\"$schema\":\"basic\",\"target\":{\"table\":\"Accounts\",\"column\":\"accountid\"},

\"operator\":\"In\",\"values\":[$a],\"filterType\":1}]",

"Alias": {"$a": "accountid"}}

</PowerBIFilter>

Power BI has a table called “Accounts”, and a column called “accountid”

The filter alias is the “accountid” field in Dynamics 365 from the account record that we are on.

Was this reply helpful? Yes No