Filter a PowerBI Report using Logged in Portal User

(0) Share

Report

Posted on by AInglis

Hi,

My requirement is to filter an embedded PowerBI Report using the ID of the logged in user.

For example the logged in users contactid is 00b12a73-dfe4-e911-a812-000d3a6aa9c8

I know i can get this using Liquid {{ user.id }}

The Embedded PowerBI Report liquid code is as follows

{% powerbi authentication_type:"powerbiembedded"ttps://app.powerbi.com/groups/5a979ca0-8340-4433-a53c-1f4159020084/reports/dbf40511-1b36-44f6-82ca-2f57524b1f4d/ReportSection?filter=cr0f3_Table/cr0f3_employeeid eq '00b12a73-dfe4-e911-a812-000d3a6aa9c8'" %}

How can I remove the hardcoded eq '00b12a73-dfe4-e911-a812-000d3a6aa9c8' and replace it with the results from {{ user.id }}?

Thanks in advance

Categories:

Power Apps portals

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

justinburch Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AInglis,
Try setting up the path as a variable if you need to manipulate it.
{% capture pbiUrl %}https://app.powerbi.com/groups/5a979ca0-8340-4433-a53c-1f4159020084/reports/dbf40511-1b36-44f6-82ca-2f57524b1f4d/ReportSection?filter=cr0f3_Table/cr0f3_employeeid eq '{{ user.id }}'{% endcapture %} {% powerbi authentication_type:"powerbiembedded" path: pbiUrl %}
Then you could even extract the URL into a Site Setting and have a different URL for each environment
{% capture pbiUrl %}{{ settings['Reports/EmployeeTable'] }}/ReportSection?filter=cr0f3_Table/cr0f3_employeeid eq '{{ user.id }}'{% endcapture %} {% powerbi authentication_type:"powerbiembedded" path: pbiUrl %}
Where you have a Site Setting with Key of Reports/EmployeeTable and Value of https://app.powerbi.com/groups/5a979ca0-8340-4433-a53c-1f4159020084/reports/dbf40511-1b36-44f6-82ca-2f57524b1f4d

Was this reply helpful? Yes No
AInglis 38 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks Justin,
I got this working, however an odd amendment was needed to your code.

When I used pbiURL as the variable Name this error was returned:
Liquid syntax error: Syntax Error in 'powerbi' tag. Missing required attribute 'path:[string]'

however when I used pbiURL1 as the variable name it worked.
It can be replicated i.e pbiEmpUrl doesn't work but pbiEmpUrl1 does.

Any idea why the addition of the number would make a difference?

Thanks

Was this reply helpful? Yes No
justinburch Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

That's an odd one, @AInglis. I'm not sure why it doesn't like that, must be some kind of reserved naming for 'url'. To be fair, Liquid templating language is built on Ruby and is very much a 'find & replace' style of language, so there are bound to be some oddities.
I'll keep this in mind, thanks for sharing and I'm glad you thought to try the number trick!

Was this reply helpful? Yes No