Forum Discussion
Edit Query measure breaking problems
I used Edit Query to add a column to an existing table; now a bunch of measures are broken. No relationships were changed or invalidated, no existing fields were removed or reformatted. This has happ...
Briefly: I have two tables 'Course Completions' and 'Courses' that have a many to one relationship on an 'ActivityId' field; I attempted to add a column to the Courses table to identify the Source [only one per course is possible], and now existing measures for Course Completions that attempt to use a RELATED() relationship to a field in the Courses
[ex:
Course Completions - Passes non-Core = SUMX(FILTER('Course Completions',RELATED(Courses[CoreType])<>"Core"), [Passes]) ]
are telling me that the column 'Courses[CoreType]' either doesn't exist or doesn't have a relationship to any table available in the current context. This measure has existed for more than a year without issue, and I have in the past added columns to the Courses table without this issue; it only started happening since I updated my Power BI to the latest.
so, the problem was that the latest Power BI desktop, when you edit queries, defaults you to Import rather than maintaining the setting you had [in my case, Direct Query]. super simple, but a huge pain as you can undo Import back to Direct Query so I had to delete the whole table, readd it, reconstruct the relationships...not a fan of this change!