Forum Discussion
OLE DB or ODBC error
Thank you for your assistance, eventually I managed to find the stupid mistake myself and that was that in a union I was doing, there was 1 singular column that switched with the one below it in the create function.
Hi Rbakker888
Thank you for being part of the Microsoft Fabric Community.
The error you're encountering, "OLE DB or ODBC error: Cannot display the data because Power BI can't determine the relationship between two or more fields," typically occurs when there are missing, ambiguous, or incorrectly defined relationships in your Power BI data model.
Start by reviewing your model to ensure all tables are correctly related using primary and foreign keys, and confirm there are no missing or mismatched relationships. Avoid circular or many-to-many relationships unless absolutely necessary, as they can confuse Power BI's ability to resolve the correct data path.
If you're using composite keys, make sure they are consistently implemented across your related tables. Alternatively, using surrogate keys can simplify your model and help avoid ambiguity.
Check that related columns have matching data types and avoid nulls or mismatches that could disrupt joins. Use the model view in Power BI to visually inspect how tables connect and ensure relationships are active and appropriate for your data logic.
Correcting these relationship issues should resolve the display error and allow your visuals to work as expected.
If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.
Thank you for your assistance, eventually I managed to find the stupid mistake myself and that was that in a union I was doing, there was 1 singular column that switched with the one below it in the create function.