The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello everyone, I have a question about this. It happens that in my dimensional table called "Dis," when, after a long time, I delete an element from a column, for example, the column called "Servicio" with the elements: a, b, c, e, d, f, and I delete the element f, I get the error message: "Query (64,323) object &[f] not found in the cube during the analysis of the string [dis][Servicio]&[f]."
Solved! Go to Solution.
Hello @Darwin98,
Here are some steps you can take to resolve this issue:
1. Ensure that the relationships between tables are still intact and correct, especially if the "Dis" table has relationships with other tables.
2. Search through your DAX formulas to see if any of them reference the missing value directly.
3. If you had any slicers or filters set to the value that was deleted, it could cause this error.
4. Sometimes, Power BI might still cache old data. You can try clearing the cache to see if it helps as "Query (64,323)" indicates of the location or source of the error (Sometimes simply refreshing can solve these discrepancies.)
Should you require my further assistance, please do not hesitate to reach out to me.
Hello @Darwin98,
Here are some steps you can take to resolve this issue:
1. Ensure that the relationships between tables are still intact and correct, especially if the "Dis" table has relationships with other tables.
2. Search through your DAX formulas to see if any of them reference the missing value directly.
3. If you had any slicers or filters set to the value that was deleted, it could cause this error.
4. Sometimes, Power BI might still cache old data. You can try clearing the cache to see if it helps as "Query (64,323)" indicates of the location or source of the error (Sometimes simply refreshing can solve these discrepancies.)
Should you require my further assistance, please do not hesitate to reach out to me.
User | Count |
---|---|
15 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
20 | |
12 | |
9 | |
7 |