Forum Discussion

FrankSindermann's avatar
FrankSindermann
Frequent Visitor
7 years ago

Error "slicerTargetDoesNotMatch" while embedded report with custom visual slicer loads

Hello, I have implemented a custom visual slicer and want to appy a filter (ISlicer with selector of type slicerTargetSelector) to that slicer in embed configuration on report load. Before the repor...
v-evelk's avatar
v-evelk
Microsoft Employee
7 years ago

Hello again,

 

Btw, have you tried to apply a filter using an other way like in this topic and this documentation?

We should check this variant before asking for assistance of embedded team because it looks like your config is just incorrect.

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]

 

FrankSindermann's avatar
FrankSindermann
Frequent Visitor
7 years ago

Hello,

 

I did what you suggested and i moved the slicer filter targeting the custom visual slicer to the filter array of embed config. The error does not occur and the report is filtered accordingly.

This is the embed config copied from browser console (some properties are replaced by three dots):

{
  "type": "report",
  "tokenType": 1,
  "embedUrl": "https://app.powerbi.com/reportEmbed?reportId=...",
  "permissions": 0,
  "viewMode": 0,
  "id": "...",
  "accessToken": "...",
  "slicers": [
    {
      "selector": {
        "__type": "Selector_slicerTargetSelector:#cca",
        "$schema": "http://powerbi.com/product/schema#slicerTargetSelector",
        "target": {
          "column": "Date",
          "table": "Zeit"
        }
      },
      "state": {
        "filters": [
          {
            "__type": "FilterAdvanced:#cca",
            "$schema": "http://powerbi.com/product/schema#advanced",
            "filterType": 0,
            "target": {
              "column": "Date",
              "table": "Zeit"
            },
            "conditions": [
              {
                "operator": "LessThan",
                "value": "2019-05-01T00:00:00"
              }
            ],
            "logicalOperator": "And"
          }
        ]
      }
    },
    {
      "selector": {
        "__type": "Selector_slicerTargetSelector:#cca",
        "$schema": "http://powerbi.com/product/schema#slicerTargetSelector",
        "target": {
          "column": "Overduegrenze (Prozent)",
          "table": "Overduegrenze (Prozent)"
        }
      },
      "state": {
        "filters": [
          {
            "__type": "FilterAdvanced:#cca",
            "$schema": "http://powerbi.com/product/schema#advanced",
            "filterType": 0,
            "target": {
              "column": "Overduegrenze (Prozent)",
              "table": "Overduegrenze (Prozent)"
            },
            "conditions": [
              {
                "operator": "GreaterThan",
                "value": 150
              }
            ],
            "logicalOperator": "And"
          }
        ]
      }
    },
    {
      "selector": {
        "__type": "Selector_slicerTargetSelector:#cca",
        "$schema": "http://powerbi.com/product/schema#slicerTargetSelector",
        "target": {
          "column": "Overduegrenze (Tage)",
          "table": "Overduegrenze (Tage)"
        }
      },
      "state": {
        "filters": [
          {
            "__type": "FilterAdvanced:#cca",
            "$schema": "http://powerbi.com/product/schema#advanced",
            "filterType": 0,
            "target": {
              "column": "Overduegrenze (Tage)",
              "table": "Overduegrenze (Tage)"
            },
            "conditions": [
              {
                "operator": "GreaterThan",
                "value": 5
              }
            ],
            "logicalOperator": "And"
          }
        ]
      }
    }
  ],
  "filters": [
    {
      "__type": "FilterAdvanced:#cca",
      "$schema": "http://powerbi.com/product/schema#advanced",
      "filterType": 0,
      "target": {
        "column": "Overdue Wesentlichkeit",
        "table": "Overdue Wesentlichkeit"
      },
      "conditions": [
        {
          "operator": "GreaterThan",
          "value": 2000
        }
      ],
      "logicalOperator": "And"
    }
  ],
  "settings": {
    "background": 1,
    "filterPaneEnabled": false,
    "navContentPaneEnabled": false,
    "layoutType": 1,
    "extensions": [
      {
        "command": {
          "name": "export",
          "title": "command export",
          "icon": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwwAADsMBx2+oZAAAAjdJREFUOE+lUG1PUnEc9TP0Ydq0NKVZ9sjESQIBAl4MlQgoQETHg6QiKIo8LXRBLtfKtTYpEVBQpwES6nTqF+hVzV64tV7o6e9tV03vm9aL87v7n52H3VMG4L/AStpLpi1r8Rm68/oj8+qTGTYNgwuEvWS8ZC+aMLUXQWw3BMOy+tt5zVmwkpac7iC2G0Rw0wNdRjXPpmFAH8d6J2xfDOgpPEVXTgvTiuYouhPE+LYPj1PUj7ZZ+ffWuHRf8UG0zxpgJebXey8wuRtGbCeE6E4AE9t+RLZ8CG0Mw7/uxljJBcn0AyJnCegu6PGKmI9b+wqdMC6poF+koM22kG8rtBklCRiE8E0DkbMEkKVhXFbDmbPQrbosBU1Gjo55KVRpMZRJIbylfqjjSvCid3F/vA63w7XEem5ETVqJ8KYX6oVmtKUleJQSoSUpgGyOD80ChcE1BwbydvTnrbgRqLkY0J5QILDhgSr1p1Ux14TmRCPEn3hoT8uJ0Qbn5x70EnBGq04DyNIgS8Oc0cFH/rUl2US3SmcbIPpYD0Gciz7SKn/3ELVj1b84I5W4NlRxGnBs9hPjKFlal1VhqPgc7rVeuAoOulWZFNOtxEybzoI+1IwEI2QkWYIPT9GJjjhFj8WduAXFtBiOVQtsK12o8V4lcpYA2XvhSetA3kGbGcHNAIeYzbAsGVDpKT/hGdBH/JYPwRQPjZNc1L+8g3uRup+M4Ppo1WH18JXDSnf5QYXr8leGZ/DX49+Bst9hj8Z3qIsn5QAAAABJRU5ErkJggg==",
          "extend": {
            "visualContextMenu": {
              "title": "Ergebnisexport"
            },
            "visualOptionsMenu": {
              "title": "Ergebnisexport"
            }
          }
        }
      }
    ],
    "localeSettings": {
      "formatLocale": "de-DE",
      "language": "en-US"
    }
  }
}

Now this is the embed config where the error occurs:

{
  "type": "report",
  "tokenType": 1,
  "embedUrl": "https://app.powerbi.com/reportEmbed?reportId=...",
  "permissions": 0,
  "viewMode": 0,
  "id": "...",
  "accessToken": "...",
  "slicers": [
    {
      "selector": {
        "__type": "Selector_slicerTargetSelector:#cca",
        "$schema": "http://powerbi.com/product/schema#slicerTargetSelector",
        "target": {
          "column": "Date",
          "table": "Zeit"
        }
      },
      "state": {
        "filters": [
          {
            "__type": "FilterAdvanced:#cca",
            "$schema": "http://powerbi.com/product/schema#advanced",
            "filterType": 0,
            "target": {
              "column": "Date",
              "table": "Zeit"
            },
            "conditions": [
              {
                "operator": "LessThan",
                "value": "2019-05-01T00:00:00"
              }
            ],
            "logicalOperator": "And"
          }
        ]
      }
    },
    {
      "selector": {
        "__type": "Selector_slicerTargetSelector:#cca",
        "$schema": "http://powerbi.com/product/schema#slicerTargetSelector",
        "target": {
          "column": "Overduegrenze (Prozent)",
          "table": "Overduegrenze (Prozent)"
        }
      },
      "state": {
        "filters": [
          {
            "__type": "FilterAdvanced:#cca",
            "$schema": "http://powerbi.com/product/schema#advanced",
            "filterType": 0,
            "target": {
              "column": "Overduegrenze (Prozent)",
              "table": "Overduegrenze (Prozent)"
            },
            "conditions": [
              {
                "operator": "GreaterThan",
                "value": 150
              }
            ],
            "logicalOperator": "And"
          }
        ]
      }
    },
    {
      "selector": {
        "__type": "Selector_slicerTargetSelector:#cca",
        "$schema": "http://powerbi.com/product/schema#slicerTargetSelector",
        "target": {
          "column": "Overduegrenze (Tage)",
          "table": "Overduegrenze (Tage)"
        }
      },
      "state": {
        "filters": [
          {
            "__type": "FilterAdvanced:#cca",
            "$schema": "http://powerbi.com/product/schema#advanced",
            "filterType": 0,
            "target": {
              "column": "Overduegrenze (Tage)",
              "table": "Overduegrenze (Tage)"
            },
            "conditions": [
              {
                "operator": "GreaterThan",
                "value": 5
              }
            ],
            "logicalOperator": "And"
          }
        ]
      }
    },
    {
      "selector": {
        "__type": "Selector_slicerTargetSelector:#cca",
        "$schema": "http://powerbi.com/product/schema#slicerTargetSelector",
        "target": {
          "column": "Overdue Wesentlichkeit",
          "table": "Overdue Wesentlichkeit"
        }
      },
      "state": {
        "filters": [
          {
            "__type": "FilterAdvanced:#cca",
            "$schema": "http://powerbi.com/product/schema#advanced",
            "filterType": 0,
            "target": {
              "column": "Overdue Wesentlichkeit",
              "table": "Overdue Wesentlichkeit"
            },
            "conditions": [
              {
                "operator": "GreaterThan",
                "value": 2000
              }
            ],
            "logicalOperator": "And"
          }
        ]
      }
    }
  ],
  "filters": [],
  "settings": {
    "background": 1,
    "filterPaneEnabled": false,
    "navContentPaneEnabled": false,
    "layoutType": 1,
    "extensions": [
      {
        "command": {
          "name": "export",
          "title": "command export",
          "icon": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwwAADsMBx2+oZAAAAjdJREFUOE+lUG1PUnEc9TP0Ydq0NKVZ9sjESQIBAl4MlQgoQETHg6QiKIo8LXRBLtfKtTYpEVBQpwES6nTqF+hVzV64tV7o6e9tV03vm9aL87v7n52H3VMG4L/AStpLpi1r8Rm68/oj8+qTGTYNgwuEvWS8ZC+aMLUXQWw3BMOy+tt5zVmwkpac7iC2G0Rw0wNdRjXPpmFAH8d6J2xfDOgpPEVXTgvTiuYouhPE+LYPj1PUj7ZZ+ffWuHRf8UG0zxpgJebXey8wuRtGbCeE6E4AE9t+RLZ8CG0Mw7/uxljJBcn0AyJnCegu6PGKmI9b+wqdMC6poF+koM22kG8rtBklCRiE8E0DkbMEkKVhXFbDmbPQrbosBU1Gjo55KVRpMZRJIbylfqjjSvCid3F/vA63w7XEem5ETVqJ8KYX6oVmtKUleJQSoSUpgGyOD80ChcE1BwbydvTnrbgRqLkY0J5QILDhgSr1p1Ux14TmRCPEn3hoT8uJ0Qbn5x70EnBGq04DyNIgS8Oc0cFH/rUl2US3SmcbIPpYD0Gciz7SKn/3ELVj1b84I5W4NlRxGnBs9hPjKFlal1VhqPgc7rVeuAoOulWZFNOtxEybzoI+1IwEI2QkWYIPT9GJjjhFj8WduAXFtBiOVQtsK12o8V4lcpYA2XvhSetA3kGbGcHNAIeYzbAsGVDpKT/hGdBH/JYPwRQPjZNc1L+8g3uRup+M4Ppo1WH18JXDSnf5QYXr8leGZ/DX49+Bst9hj8Z3qIsn5QAAAABJRU5ErkJggg==",
          "extend": {
            "visualContextMenu": {
              "title": "Ergebnisexport"
            },
            "visualOptionsMenu": {
              "title": "Ergebnisexport"
            }
          }
        }
      }
    ],
    "localeSettings": {
      "formatLocale": "de-DE",
      "language": "en-US"
    }
  }
}

Best regards

 

  • v-evelk's avatar
    v-evelk
    Microsoft Employee
    7 years ago

    Hello,

     

    Do I correctly understand that this solution is sutable and your issue is solved or you still need my assitance?

     

    Kind Regards,

     

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]

  • FrankSindermann's avatar
    FrankSindermann
    Frequent Visitor
    7 years ago

    Hello,

     

    this solution is not suitable because the filter pane is set to hidden in the embed config. So the user who opens the report has no other possibility to change the filter.

     

    I to want use the second embed config as posted in my last reply to filter the report with slicers.

     

    Many thanks for your effort

    and best regards

  • v-evelk's avatar
    v-evelk
    Microsoft Employee
    7 years ago

    Hello,

     

    Well, I suppose we should ask advice from embedded API team.

    Could you please send full descriptions with examples and pictures to [email protected] ?

    I will transfer the question to them and will provide the info here when they answer.

     

    Kind Regards,

     

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]