Error in visual in Service

[Anonymous]

Hi All,

please help me in this case:

I got this message after I published my pbix file to my service.. But until this, I did not have this error message so now I don't understand it why?

That Customer Name field is depends on another column but until this it was not a problem. It's a text field so nothing depends on date fields that I red about.. So please help me what can be the problem?

Many thanks!

Mate

[v-lili6-msft]

hi, @Anonymous 

Here is a similar post for you refer to:

https://community.powerbi.com/t5/Service/The-query-referenced-column-which-depends-on-another-column/td-p/166866

Please check [Customer Name] and the related column of it.

Could you try to delete [Customer Name] field and try it again. and what is the formula of [Customer Name] field?

Could you share a simple sample pbix file for us have a test?

Best Regards,

Lin

[Anonymous · Accepted solution]

Hi @v-lili6-msft ,

Thanks for the link I already red everything about it, but I could solve the problem by my own. The Loookupvalue function caused the problem, I changed it with other formulas and it works. 

But I don't really don't know why was it a problem now and not anytime before??

Thanks,

Mate

[v-lili6-msft]

hi, @Anonymous 

It's pleasant that your problem has been solved,  

It is not a common problem, It needs to combine specific data to analyze, for your problem, it is caused by Loookupvalue function. You may try to check the data, that should be something wrong in it.

please accept the reply as solution, that way, other community members will easily find the solution as a reference when they get same issue.

Best Regards,

Lin