cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lmfk8
New Member

Allow users to provide responses to report

Hi there,

I'm new..ish to Power BI and have been looking for a way to do this but couldn't find anywhere, so I thought I'd ask to the community.

I work in Audit and have been using Power BI to report on some audit findings.  In fact we have some audit tests that run continuously and the business users can review the results to address any potential exception.  A simple example would be a test for duplicated payments made by AP, where the AP staff will look at the Power BI report and click on the transactions to then further investigate.  The outcome can be, for example, a confirmed duplication which AP then seeks refund, or a false-positive.

Now, here's what I'd like to have in my report: a way for the AP staff to enter the outcome of their review, so I could add an additional visual to show the actions taken by the business and what the outcome was.  This would be useful to me as I could check whether the potential exceptions are been investigated properly.

I know of other tools (audit specific) that have this functionality, but they obviously lack in many other areas where Power BI excels, so I'm trying to see whether there's a way to implement this.  The only way I could think so far was to have the results on an Excel spreadsheet which I'd provide to the business for them to enter their review outcomes and then link Power BI, but if I could do all from within Power BI only that would be ideal.

Any ideas would be greatly appreciated!

1 REPLY 1
Anonymous
Not applicable

Power BI is a read-only application.  It doesn't allow for any updates or editting of data.

 

You can, however, embed PowerApps into PowerBI.  Potentially you can write an App that could facilite what you are looking for.  I haven't personally tried it, so I am unsure of the Pros and Cons of doing so.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors