Forum Discussion

Darwin98's avatar
Darwin98
Frequent Visitor
2 years ago
Solved

I cannot update data.

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 "Servici...
  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    2 years ago

    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.

Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
2 years ago

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.