We have many "report .pbix" files that are reports with a live, "Power BI datasets" connection to a common dataset. In some of these reports, we have created what I'd call "additional measures." That is, these measures were created in the "report .pbix" only, and the measures don't exist in the dataset to which it has a live connection.
Since several days ago, approximately, many of our users (and I) have experienced the follwing issue...
Sometimes when we open the report .pbix in Power BI Desktop, some visuals are broken because the "additional measures" seem to be missing. The visual says: "Something's wrong with one or more fields" or "Something's wrong with one or more filters." And when we click "See details," the pop-up says: "Can't display this visual. This visual contains one or more filters with deleted columns, type mismatches, or other breaking model changes." Or the pop-up says: "Fields that need to be fixed / Something's wrong with one more more fields: MeasureA, MeasureB."
And when I look in the "home table" where the measures should reside, they are not there anymore! This only seems to happen with "additional measures" that are created in the "report .pbix," which is connected live to a published dataset. (We have not experienced this issue with measures that exist in the dataset.)
And it happens only intermittently -- sometimes, seemingly at random. For a given file, sometimes it happens when I open it in Power BI Desktop, sometimes it doesn't. When this issue occurs, I can close Power BI Desktop (without saving any changes); then re-open the exact same file, and everything is fine -- the visual has no errors, and the "additional measures" appear in the expected home tables.
As a test, I just closed and re-opened one such file 10 times, without doing anything else on my computer in between, and this issue occurred 5 out of the 10 times.
I am using Release: December 2020 / Product Version: 2.88.802.0 (20.12) (x64) ... this may only happen with the December release of Power BI Desktop. Haven't tested with older versions.
v-xiaoyan-msft
on:
Refresh dataflows from other users
on:
Something went wrong Token '=' expected