Forum Discussion
SQLite Imports
Hello all, I am currently working on a database modeling project with Power BI and SQLite. My goal is to have my SQLite database relationships (which I import through ODBC) modeled by exclusively...
I have the same issue where Power BI does not recognise the foreign key relationships. I think it might be related to having a primary key (which the foreign keys link to) in one table that is recognised as decimal instead of integer. The create table statement for that column is defined as "MetaID INTEGER PRIMARY KEY AUTOINCREMENT," so I'm not sure why Power BI thinks its a decimal. Other tools that open the database don't make this error.