Share
ReportI am trying to dynamically filter a Power BI report I have embedded in a Powerapps Portal. I have tried unsuccessfully to use the info supplied in the Dataverse Entity Tags article dated 10/12/2022.
I created a custom entity in Dataverse called Payment Applications. I imported the Payment Application table into a PowerBi Report (I refresh the data daily). I created a list and forms in Portal Management for the Payment Application table.
The report is based on a dataset imported from Dynamics 365 tables (via the legacy D365 data connector). The report contains multiple tables. The table at issue here is named Invoices.
The report is embedded in a page that displays a record from one of the imported tables. For example, the Dataverse table is named Invoices. The portal page in question contains a form to edit a record from the Invoices table.
I tried a filter like this (I know I'm missing the escape characters in this case):
{% capture pbi_path %}https://app.powerbi.com/groups/.../reports/.../ReportSection...?filter='Payment Applications'/PrimeContractTextID eq '{{nor_primecontract_name}}'{% endcapture %}
{% powerbi authentication_type:"powerbiembedded" path:pbi_path %}I think I may need to capture the record id from the URL of the page displaying the edit form for the record, but I don't know how to use that id. The link to the record looks like https://acme.com/PaymentApplications/..../?id=... 002248047c6b
All responses (
Answers (
7,044
