web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps PowerBI Connector link...

Power Apps

Unanswered

PowerBI Connector link to PowerApps

(0) Share

Report

Report

Posted on by bazz12

21

I hope someone might help with an issue while adding PowerBi tile to PowerApps. Couple of issues that I need support here with the integration-

1- The PowerBi tile once linked in the PowerApps- the look & feel of the tile in PowerBI dashboard looks different in PowerApps, has anyone come across this situation?

2-Filter criteria for PowerBI, I am trying to add two filter conditions with &&(AND) operator, both the conditions working independently but when I use AND operator the PowerApps seems to ignore the second condition, please advise a way to resolve this issue?

Thank you in advance.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bazz12 ,

For your first question, yeah, you right. When you add Power BI Tile control in your canvas app to display your Power BI dashboard Titles, it would have different appearance style as that in your Power BI itself. Maybe the size of the Tile is small.

You could consider adjust your canvas app layout into Tablet Layout, then the Power BI Tile could display better appearance within your canvas app:

For your second question, do you want to append multiple filter criteria along with the Tile Url? When you want to append multiple filter criteria along with the Tile Url, you should use 'and' operator rather than "&&". So you need to modify the TileUrl property in Power BI Tile control as below:

"https://app.powerbi.com/embed?dashboardId=82d341ed-a20e-49eb-b0ba-9d9f0aa77a99&tileId=50350e04-819d-433b-87a3-128350db5db5&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly9XQUJJLVNPVVRILUVBU1QtQVNJQS1yZWRpcmVjdC5hbmFseXNpcy53aW5kb3dzLm5ldCIsImVtYmVkRmVhdHVyZXMiOnsibW9kZXJuRW1iZWQiOmZhbHNlfX0%3d&$filter=<TableName>/<ColumnName1> eq '<Value1>' and <TableName>/<ColumnName2> eq '<Value2>'"

More details about the Filter parameters in Power BI Tile control, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-power-bi-tile

More details about the operators supported in filter report URL, please refer to the following article:

https://docs.microsoft.com/en-us/power-bi/service-url-filters#operators

Best regards,
bazz12 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for sharing the articles and tried your suggestions, but AND condition is not behaving what I expect. I have two conditions, e.g. Region='NAM' and Group='Field', the report is filtering with no issues when I use either region or group but when I use the conditions together I don't get the desired output.

Join the conversation