New column in SSAS not showing data in Power BI

[Yashodhan]

I have created new column in SSAS model and in SSAS model that column is showing okay , but whenever I use this column in power bi ..it is showing error like cant load the data for this visual .please help me to solve this issue

[lukiz84]

And which measure do you use in PowerBI? Can you post this one too?

[Yashodhan]

tried with Slicer,table ,card

[lukiz84]

and where do you check if "in SSAS it's correct"? 🙂

[Yashodhan]

it is deployed and can show the column contents

[lukiz84]

Did you refresh the model?

[Yashodhan]

Yes..refreshed, processed and deployed successfully 

[Yashodhan]

In case of SSAS it is not showing any error it runs okay '

[lukiz84]

It says everything.

You created a calculated column but the expression you used throws an error. Show us the expression please.

[Yashodhan]

= IF(('On Hand'[Locator]= ""),"Blank",
IF(CONTAINSSTRING('On Hand'[Locator],"236"),"REMP",
IF(CONTAINSSTRING('On Hand'[Locator],"235"),"JEPM",
IF(CONTAINSSTRING('On Hand'[Locator],"238"),"CME",
IF(CONTAINSSTRING('On Hand'[Locator],"240"),"HAGE",
IF(CONTAINSSTRING('On Hand'[Locator],"376"),"SKOV",
IF(CONTAINSSTRING('On Hand'[Locator],"577"),"DED",
IF(CONTAINSSTRING('On Hand'[Locator],"618"),"CEK", "NA"))))))))