Answered

PowerBI Integration with Drop Down functionality

(0) Share

Report

Posted on by mterry

I've watched a few tutorials on integrating write back capabilities in Power BI, and so far every one that I've watched has been reliant on the user selecting a record in a visual (usually table) in PowerBI in order to populate data in the PowerApps visual and then add/edit data to the original source. I was curious to know if that step was mandatory? What I was initially hoping to do was have a PowerApp that had a dropdown where the users could select an order number that was in the PowerBI report without clicking on any other visual? I haven't been able to get it to populate experimenting with LookUp formulas using the PowerBIIntegration.Data, but certainly could be getting the formulas/syntax wrong. Any advice on how I could achieve this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

EddieE 4,641 Moderator on at

Like (0)

Report

The PowerBIIntegration.Data is a 'Table' built by the Power BI report after the user makes a selection, so you wouldn't use this for your app dropdown. Simply reference your backend data source of the report, for example SQL.

Process / Pseudo code

- User looks at report and eyeballs an Order number

- Users selects required O/N from dropdown

- PowerApp looks up O/N in data source

- Users makes changes and changes are Patched to the data source

- If using Direct Query data source, users will see changes immediately if you add PowerBIIntegration.Refresh() to the end of your Patch

@mterry

Was this reply helpful? Yes No
mterry 84 on at

Like (1)

Report

Ok will go this route, thanks. When doing so, it looks like trying to connect PowerApps to a datasource can only be done with Excel files via OneDrive for Business, not csv files. Is that correct?

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like (0)

Report

@mterry

If those are your only 2 available options, then Yes, only Excel in OneDrive for Business is available for you to use. Cannot connect apps to csv files.

Was this reply helpful? Yes No