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 ...
  • 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