Forum Discussion
OLAP to Tabular, filter issue in Power BI
Hi Bchocho
Please check the following points:
1.Please check whether the column name changed, that will cause the proplem, you can remove the field from the filter, then put it to the filter again.
2.Check the data type is changed, that it may cause the problem.
And you can refer to the following link.
Solved: This field can't be used since it is invalid - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
First of all, thank you very much for your feedback on my post.
The column names have been checked and are unfortunately not the cause of the problem.
As far as the data types are concerned, we don't always have the same data types for the same column between the OLAP model and the tabular model, but the problem is present even when the data types are identical between the 2 models.
Thanks for the link, I hadn't seen it, but it doesn't answer the problem. In the post, the headings are missing from the filters, whereas in our case the headings are present in the filters but are not linked to the columns bearing their names. The error appears as follows :
Best regards