Unanswered

Anyone successfully using a filter with the Power BI Data integration?

(0) Share

Report

Posted on by arpost

466

I have a Power BI report to which I've added the Power Apps visual. In the Power App, I'm trying to display all records from a SharePoint list that match existing values in the Power BI report. However, I can't use a typical filter because columns coming from Power BI are tables despite the fact that they are just columns in Power BI.

As shown in the image, I am wanting to filter my SP List in Power Apps so that it shows all records that contain any of the displayed Distributors in Power BI, so if Power BI shows "Company A, Company B, Company C," I want to see all SP items for Companies A, B, and C.

Anyone have any ideas?

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

PowerApps Power BI Integration Dynamic Filtering - YouTube

Filters will work like this in powerapps.
arpost 466 on at

Like
a
(0)

Report
Copy link

Link copied!

@zmansuri, thanks for providing that video. That actually helps me with another project. Unfortunately, this doesn't quite address my scenario for this thread as the tutorial deals with using the Power BI tile in a Power App rather than using the Power App visual in a Power BI report (see below).

Thanks again for posting, though.
AkshayManke 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @arpost, have you got any solution for your scenario?