Join paths are expected to form a tree - Visual Errors in the Service

[mcgilla]

I have two reports which are generating this error in the Service as of this morning.  The reports have been running for the last 2 years with no issues.  There are no errrors on the desktop version of the report and everything is viewable and working.  I am not using RLS.  Anyone expieriencing any issues as of the 21st with the service?

thanks  

[andrewsimmans]

Hi,

Is the relationship causing the issue a 1 to 1 - it is for me.

By changing this to a 1 to many (but keeping the cross filter direction as both), this seemed to resolve the problem. What I can't figure out is if this will make any difference to the values reported. 

[Anonymous]

Same thing here. Started 1 or 2 days ago. Power BI Desktop works fine.

I think the PowerBI Service is thinking RLS is enabled even if it is not.

[andrewsimmans]

Yes - thisstarted happening for me from last night (21st) on something that has been running OK for many years.

[Anonymous]

Hi @mcgilla 

Same qn is discussed here. Hope this helps you.

Solved: Test Role : Join Paths are expected to Form a Tree... - Microsoft Power BI Community

Thanks
Raj

Thanks

Raj

[mcgilla]

Thanks but that doesnt answer my question, its working perfectly in the desktop, once its published it doesnt show.  There is no RLS involved either.