Forum Discussion
exceptionDataMessage issue when trying to create a relationship
Hi Anonymous ,
1. Check for residual references: Even though the 'Problems' table has been deleted, there might be residual references to it in your model or in other tables. There might be other objects in your model (like measures, calculated columns, or other relationships) that are still referencing the 'Problems' table. You could review your model to ensure there are no remaining references to the 'Problems' table Please check all your tables and relationships for any leftover references to the 'Problems' table and remove them.
2. Caching Issue: Sometimes, systems cache the schema of the database for performance reasons. If the 'Problems' table was recently deleted, the system might still be referencing the cached version. You could try refreshing your database connection or restarting your SQL endpoint to clear the cache.
3. Metadata Inconsistency: The metadata of your database might not have been updated correctly after the 'Problems' table was deleted. You could try to rebuild the metadata of your database.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
- ableijs-cs2 years agoNew Member
Hi Anonymous
I have the same issue too.
However, I have no clue how to implement your suggested solutions:
- 1.: This is not the case (I think). The deleted table was never used.
- 2.: Refresh your database connection or restart your SQL endpoint: How do I restart my SQL endpoint? Do you mean close the browser screen and reopen it? Tried it, didn 't work,
- 3.: Try to rebuild the metadata of your database: 1) It isn't a database, but a Fabric Lakehouse; 2) How do i rebuild metadata things in Fabric? The whole idea of SaaS is, that metadata etc are hidden from us.
Hope you can help.
Best regards,
Arne Bleijs
- Oddy2 years agoFrequent Visitor
Did you ever figure out what caused this? I am having the same issue