Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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