User relevant Power BI components in Power Pages
Do you want to have a different Power BI component configuration in Power Pages depending on who is logged in, making the data user relevant?
Some background
How about creating a page in Power Pages that lets you display Power BI reports depending on the user that is logged in? So depending on which company a user works at, they get a different report shown?
So for different companies I have a different Power BI report to be displayed.
In this post I will give an example of how to implement this. You will need to get a little familiar with Liquid first. So please have a look at my post introducing Liquid first.
If you are completely new to Power Pages then have a read through my ultimate user guide on Power Pages
Get the company
In my case I don’t really want to company name of my logged in user. I rellay want the get the domain of the user. So the but after the @ sign in their email address.
To get the part after the @ sign we can use the filters split and last as shown below:
{% assign mycompany = user.emailaddress1 |split:"@" |last %}
{% if mycompany %}
<div style="padding: 8px; margin: 0px; display: flex; flex-wrap: wrap; text-align: left; min-height: 50px;"> Your Company: {{ mycompany }} </div>
{% endif %}Then the last few lines will display the domain name of the user logged in.
Get the data
Now we need to get the data from a table that we created that holds the links to Power BI
We will use a fetchXMl for this:
{% fetchxml mylinks %}
<fetch version=”1.0″ output-format=”xml-platform” mapping=”logical” distinct=”true”>
<entity name=”creb7_clientpowerbilinks”>
<attribute name=”creb7_powerbilink” />
<attribute name=”creb7_name” />
</entity>
</fetch>
{% endfetchxml %}
In the above coded there are a few things to notices. The data that is read with the fetchxml is stored within a variable mylinks. Then the table that is being read has a logical name, creb7_clientpowerbilinks and there are two fields creb7_powerbilink and creb7_name.
Processing the data
So no we have an array called mylinks with all the data that we want. using a for loop we can display a Power VBI report with the link in question.
{%for item in mylinks.results.entities %}
{% if item.creb7_name == mycompany %}
{% powerbi authentication_type:"aad" path:item.creb7_powerbilink %}
{% endif %}
{% endfor %}Display the Power BI component
For ease here is the full code as built up in this post.
{% assign mycompany = user.emailaddress1 |split:"@" |last %}
{% if mycompany %}
<div style="padding: 8px; margin: 0px; display: flex; flex-wrap: wrap; text-align: left; min-height: 50px;"> Your Company: {{ mycompany }} </div>
{% endif %}
{% fetchxml mylinks %}
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
<entity name="creb7_clientpowerbilinks">
<attribute name="creb7_powerbilink" />
<attribute name="creb7_name" />
</entity>
</fetch>
{% endfetchxml %}
{%for item in mylinks.results.entities %}
{% if item.creb7_name == mycompany %}
{% powerbi authentication_type:"aad" path:mylink.creb7_powerbilink %}
{% endif %}
{% endfor %}The above code should then give you the Power BI report in your Power Pages that is built up dynamically.
Continue Reading Pieter Veenstra’s Article on their blog
User relevant Power BI components in Power Pages
Do you want to have a different Power BI component configuration in Power Pages depending on who is logged in, making the data user relevant? How about creating a page in Power Pages that lets you display Power BI reports depending on the user that is logged in?
Blog Syndicated with Pieter Veenstra’s Permission
More About This Author
Array
Modern Workplace26 March 2024Receive the available storage within your SharePoint Online tenant- Modern Workplace20 March 2024Options for Documenting Your Power Apps: Comments, Code, and Controls
- Modern Workplace18 March 20242 ways to duplicate SharePoint Lists to support your Power Apps
- Modern Workplace14 March 2024Update a Hyperlink Column in SharePoint with Power Automate
