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.
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>https://app.powerbi.com/reportEmbed?reportId=aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee</TileUrl> <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>
Have you tried the Power BI Embedder tool in the XrmToolBox? It's not 100% flawless but it might give you something to go on.
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.