Forum Discussion

mark_endicott's avatar
mark_endicott
Icon for Super User rankSuper User
4 years ago

An incompatible filter is used on a column with a parameter mapping.

Hello,    I set up a Dynamic M Query Parameter and bound it to a field in one of my dimensions. Since doing this I received the following error on some of my visuals: "An incompatible filter is use...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi mark_endicott ,

I cannot reproduce the error. Could you please provide more details? At what point did this error occur? After you wet th parameters? What is the type of the parameters?

 

We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/

 

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mark_endicott's avatar
mark_endicott
Icon for Super User rankSuper User
4 years ago

Anonymous it is a text parameter created in Power Query.

 

I used "Bind to parameter" on a column to create a Dynamic M Query parameter according to your documentation. Except I used a column that had a TopN filter set up on the filter pane. When I published the data model to the server the error "An incompatible filter is used on a column with a parameter mapping." appeard. 

 

So I then went back to the column and set "Bind to Parameter" to none and republished the model, I still receive the same error. 

 

So I then went back to power query and deleted the parameter and republished the mode, I still receive the same error. 

 

I have looked at your Support page, and there is no suitable category to raise this issue. Please can you suggest one.

 

Thanks, 

Mark