SQLite Imports

[Anonymous]

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 using the primary & foreign keys of the database once it is imported.

I have a number of fields accross database tables with similar names so I turned off the autodetect relationship setting inside of the Data Load menu to prevent automatic relationships between these:

However, once I load the data with this setting turned off, no relationships are created between my tables:

I also ensured that my ODBC data source has foreign keys enabled:

Since SQLite wasn't working how I expected, I wanted to try this same database out with MySQL. I turned off the same Data Load setting and it seemed to import the primary/foreign key relationships without a problem:

I've been searching around in the Power BI Community for answers related to this problem, but I have yet to find a solution. Ideally, I'd like to keep using SQLite since it is compact and doesn't rely on a running server like MySQL. If anyone has any thoughts or suggestions on how I may resolve this issue it would be much appreciated.

Thank you!

[QuantDev1984]

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. 

[V-lianl-msft]

Hi @Anonymous ,

According to my attempt, I can't reproduce your issue.Power BI Desktop will try to find existing relationships in the tables that are about to be imported.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.