Forum Discussion

pyskaty's avatar
pyskaty
Frequent Visitor
5 years ago
Solved

Power Bi embedded - interaction through dataSelected event

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's avatar
    Anonymous
    5 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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