cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tlawsonpinewalk
Frequent Visitor

Trigger Patch on Change of PowerBI input

Hello,

 

For one of my PowerBI reports I'd like to be able to create an audit table of the records that my users are looking at (as this will be useful to prove to my auditors that the actual records are being reviewed).  I know there are usage stats built in to PowerBI but I am interested in the specific records that they filter on.

 

I can have a simple PowerApp that patches an audit table every time the PowerBIIntegration.Data value changes except that I can't find a way to trigger the Patch formula.  Setting a default value of a text input for example does not trigger the patch formula, the text input requires user interaction but I am trying to make this work passively.

3 REPLIES 3
v-siky-msft
Community Support
Community Support

Hi @tlawsonpinewalk ,

From my experience, I don't think your requirement is available in PowerApps, we have no ways to recognize the change of PowerBIIntegration.Data.

If you want this feature, please submit an idea to PowerApps Ideas Forum:https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas 

Best regards,

Sik

Hello,

 

Thanks @v-siky-msft 

 

I will add it as an idea.  I have come up with a solution that relies on a timer, every 10 seconds the app compares two data fields, if they are the same then it does nothing, if they are different (and thus the implication is that the user has changed the PowerBI data) then it will perform the Patch.

I know this is an old post, but since it hasn't been solved, I thought I'd share what I was able to do. It may be a bug in PowerApps, as I stumbled over this by accident, but a combo box OnChange() event is triggered by a change in PowerBIIntegration.Data change. I added a hidden one that set a few variables when it was changed and it's all working well now. 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (3,437)