Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello There,
I have a PowerBI report which is connected to the Data Model in Fabric to a Development workspace.
I have deployed the Data Model from Dev to Prod. How ever the app has it own secondary model which contains calculation group and measure table. This secondary model was moved too to PROD.
All page of the report shows up fine. Unless the page with the Calculation group which gives the error "he query referenced Calculation Group Table 'Time Intelligence' which does not hold any data because it needs to be recalculated or refreshed"
However, when I publish this report directly from PowerBI desktop to Prod this issue does not exist.
What could be the issue ?
Solved! Go to Solution.
The calculation group was built in PowerBI and not in Tabular editor. We had some issue with setting up right security access too with Fabric. We implement service principal and refreshed the pry and secondary schematic model and the report and it fixed the error.
The calculation group was built in PowerBI and not in Tabular editor. We had some issue with setting up right security access too with Fabric. We implement service principal and refreshed the pry and secondary schematic model and the report and it fixed the error.
Yes. Closed now
Hi,
If you think my answer provided some kind of a soulition, please consider accepting it as soulition and click the button. I also greatly appreciate if you give me a kudos 🙂
Br
Marius
Hi,
It means you just need to recalculate the model for it to work. If you use Tabular Editor just right click on model and push refresh > calculate model.
Or just run a full refresh on the model from service.
Br
Marius 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
24 | |
20 | |
19 | |
15 | |
14 |
User | Count |
---|---|
34 | |
27 | |
27 | |
23 | |
21 |