I have a stable PBIX report (in use for 6+ months) that reads from a set of SQL Server database views. Recently, we pulled in a few more objects from the same source (these were tables and not views,...
Hi v-qiuyu-msft,
No. The new imported tables are retained, it is only the measures/calculated fields that are disappearing.
And the changes are definitely saved. If I open the PBIX, I see the measures. But once I refresh, they're gone.
If I now choose to not save and go back to the old file, I still see the old measures. So the refresh is what causes the issue!
Now when I lose the measures, and I now recreate a new measure on this refreshed PBIX, that measure gets retained. So I'm unable to explain why only in a certain case the measures don't get retained on refresh.
I don't want to recreate everything before understanding this behaviour, lest it occurs again. Please help.
Regards,
Srivathsan