Forum Discussion
Solved
SSAS Sort By Column Causing Data Cannot Display Visual Error
Power BI does not seem to understand SSAS attributes that have an order by attribute assigned to them. When attempting to build a visual, it will X itself out and say that it cannot be displayed. ...
I could not get VARCHAR types to sort in my Store Dimension only in Power BI, but if I use Integers it works. I was able to sort attributes in different dimensions using the VARCHAR type. It wouldn't work in the Store Dimension even after rebuilding. Integers it is.
not solved..!
But we have found a workaround. The problem happens with not numeric fields that are bigger than varchar(50). We are changing the field length to less than 50 positions and the problem was solved.