Power Platform Community Forum Thread Details

Hello,

I’m experiencing an issue and was wondering if anyone else has encountered the same problem or found a solution.

In PowerApps, I’m using the native Power BI viewer to display a Power BI report inside a Canvas App. However, persistent filters do not seem to work when the report is embedded this way. When users switch back to viewing the report directly in the Power BI Service (via a web browser), they can see all of their previously applied filters as expected.

From what I’ve found in the documentation, enabling persistent filters for embedded Power BI reports may require using JavaScript.

Since PowerApps does not allow custom JavaScript, I’m unsure how to enable this functionality in a Canvas App. Has anyone else faced this issue? Is there a way to enable or work around persistent filters for a Power BI report embedded in a PowerApps Canvas App?

Thanks in advance.

Categories:

Building Power Apps

Hi @JohnMarkPerez

I took a look at this. I had hoped someone else would reply, but since they did not.

Persistent Filters for Power BI reports is only exposed thru using JavaScript. There doesn't seem to be any other way. (I had even tried to look at the possibility of creating an Azure Function to implement the functionality.) As you have found, Canvas Apps do not expose this. I tried to see if someone had written a PCF Control to do this, but I was not able to find anything.

The best I can come up with is to use a Model Driven App to get you access to JavaScript. You may need to write your own PCF control to access the persistent filters. I could not find a specific PCF control that exposed this. Host your Canvas App in the Model Driven App.

Sorry I don't have a better answer for you. This is one of those cases where the functionality is right there but you can't get to it. Which as a developer is extremely frustrating.

This community is supported by individuals freely devoting their time to answer questions and provide support. They do it to let you know you are not alone. This is a community.

If someone has been able to answer your questions or solve your problem, please click Does this answer your question. This will help others who have the same question find a solution quickly via the forum search.

If someone was able to provide you with more information that moved you closer to a solution, throw them a Like. It might make their day. 😊

Thanks
-Mark