I built a Power BI report by importing two semantic models from other reports. In those original reports, I had created tables with calculated results since it would be unfeasible to rebuild all calculations in the new report.

Everything worked fine in Power BI Desktop, but after publishing, the visuals didn’t appear, and I got a QueryUserError. I tried several fixes, such as checking build permissions across all three reports and reconnecting the datasets, but nothing worked.

The only workaround that worked was recreating the calculations directly in the imported tables instead of using measures. After republishing, it worked — but once I refreshed the dataset, the error came back. Now I’m not sure what else I should do to fix this.

I built a Power BI report by importing two semantic models from other reports. In those original reports, I had created tables with calculated results since it would be unfeasible to rebuild all calculations in the new report.

Everything worked fine in Power BI Desktop, but after publishing, the visuals didn’t appear, and I got a QueryUserError. I tried several fixes, such as checking build permissions across all three reports and reconnecting the datasets, but nothing worked.

The only workaround that worked was recreating the calculations directly in the imported tables instead of using measures. After republishing, it worked — but once I refreshed the dataset, the error came back. What else should I do to fix this?