Power Bi embedded - interaction through dataSelected event

[pyskaty]

hello,

I'm trying to implement interaction between my app and embedded power bi raport. I've seen demos with dataSelected event but this all seems to be insufficent. 

Let's say I have a table that shows users: user name and some aggregated data. I click on user name and through dataSelected event I can get 'user name' value and nothing more. Using 'user name' as a key to do something on my app side is not acceptable. I need userId. I don't want to put userId as a column in table visual. 

Is there any way to pass something 'extra' with dataSelected event? Not only value that was clicked.

best regards,

JJ

[Anonymous · Accepted solution]

HI @pyskaty,

For the 'data selected' event, it seems only got the current operation fields. So if you not add the field to your report visuals, it was not pick up other fields value based on the 'data selected' event.

In my opinion, I'd like to suggest you add processing with rest API to lookup specific value fields. The data selected event will show the table and column which the filter/slicer hosted.
if they stored in the same data table, you can use the rest API to get the data table and use the current value as a parameter to find out other field values.

"dataPoints": [
    {
      "identity": [
        {
          "target": {
            "table": "Product",
            "column": "Manufacturer"
          },
          "equals": "xxxxxx"
        }
]

Push Datasets - Datasets GetTables 

Regards,

Xiaoxin Sheng