Hello. My end goal is to click on some data in PowerBI, and have it auto-fill a couple fields in the entry form in my PowerApp. However, I cannot seem to get any sort of connection to my data via PowerBIIntegration.
Here's the steps I've taken:
- Create an Excel File on OneDrive with an empty table, with the following headers:
- Create an app in PowerApps, linking to my excel file in OneDrive.
- Save and publish the app.
- In PowerBI, I add a PowerApps visualization, and select my two datapoints; "SKU" and "Market"
- Click "Choose App", and select my app.
- Click "Go to Power Studios" to finalize the data connection and get PowerBIIntegration added.
- Alt-Click the "+" in my app, to go to the entry page.
- Click the Marketplace text field, and edit the default value.
- I'm prompted to unlock the field, so I do so
- From other forum posts, I believe I'm supposed to enter a formula like this:
First([@PowerBIIntegration].Data).Market
But doing so has the red error squiggly under ".Market" saying "Name isn't Valid. This identifier isn't recognized."
I assume that it's unable to lookup any contextual data within the PowerApps creator, so I save and publish with the hopes that my formula works in the embedded version of the app in PowerBI.
However, when I refresh PowerBI, load the PowerApp, click the "+", and then click on a marketplace on a separate visual in PowerBI, nothing pops up in the entry form.
What am I missing or doing wrong?
