You’re offline. This is a read only version of the page.
8
Hi everyone!
I'm following a structure similar to the one below to get my report automatically filtered based on user's selection in Dynamics365 form (let's say based on user's country I would like to have the report auto filtered when he/she opens the form).
However, the filtereing is not working. I'm trying with an alias (PBi->Dynamics name) but it doesn't work. Also tried with hardcoded values , but doesn't work.
Any ideas on this topic?
<section id="{d411658c-7450-e1e3-bc80-07021a04bcc2}" locklevel="0" showlabel="true" IsUserDefined="0" name="tab_4_section_1" labelwidth="115" columns="1" layout="varwidth" showbar="false"> <labels> <label description="Filtered Power BI embedding demo" languagecode="1033" /> </labels> <rows> <row> <cell id="{7d18b61c-c588-136c-aee7-03e5e74a09a1}" showlabel="true" rowspan="20" colspan="1" auto="false"> <labels> <label description="Accounts (Parent Account)" languagecode="1033" /> </labels> <control id="filteredreport" classid="{8C54228C-1B25-4909-A12A-F2B968BB0D62}"> <parameters> <PowerBIGroupId>00000000-0000-0000-0000-000000000000</PowerBIGroupId> <PowerBIReportId>aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee</PowerBIReportId> <TileUrl>app.powerbi.com/reportEmbed <PowerBIFilter>{"Filter": "[{\"$schema\":\"basic\",\"target\":{\"table\":\"Accounts\",\"column\":\"accountid\"},\"operator\":\"In\",\"values\":[$a],\"filterType\":1}]", "Alias": {"$a": "accountid"}}</PowerBIFilter> </parameters> </control> </cell> </row> <row /> </rows> </section>]
