Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I've made some changes in the cube connections both in the test and in production.
The test report does work, but production give me an error:
"The expression referenced a relationship between 'Sales'[EntryDateKey] and 'Calendar Entry Date'[DateKey],
which does not hold any data because it needs to be recalculated."
I have the same reports for both environments. I have no idea, what can be the reasone and how to resolve it?
Thanks
Solved! Go to Solution.
You need to open SMSS, connect to the desired database via XMLA and click "Process Database". After completing this operation, everything will work.
You need to open SMSS, connect to the desired database via XMLA and click "Process Database". After completing this operation, everything will work.
@Anonymous,
You might need to check the relationship between the two tables.
Thank you for your answer, but, that was the only issue with the process i should made. After the processing the problem disappeared.
Hi, I am facing the same issue and was wondering if you could clear on what do you mean by the line:
"the only issue with the process i should made. After the processing the problem disappeared."
Thanks in advance.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |