Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |