Power BI Service- Report Update Error

[Jrubio93]

I can not load some visuals from my report, this error prompts on Power Bi Service "The query referenced a relationship between 'ContactID'[contactid] and 'Merge (Contact-Serviceappointment)'[contactid], which depends on a column that is not in a valid state".

Thanks!

[Anonymous]

Hi @Jrubio93 ,

There have been users with similar experiences to you in the past, you can view the original post

Solved: The query referenced column ****** which depends o... - Microsoft Power BI Community

"The problem was that on Power BI Desktop, if you use int values on imported files those “variables” works fine.

But when you upload that and update, the Power BI Service don’t understand as int, and the problem come when you use related() and calculation.

Then I have changed all the columns from integer to number % and everything is fine now on the Power BI Service."

Best Regards,
Community Support Team _ Caitlyn

[Jrubio93]

In my case, the column Contactid that is prompting the error, it is on TEXT type, not interg neither number.

What do you suggest me? - Thanks

[Jrubio93]

Still facing the same issue... I am not using int values on imported files.