Use ROWID field of a Sqlite table in PowerBI

[Anonymous]

First connect powerBI whith sqlite database file here 

But How can I use ROWID field into my powerBI relations?

Thank you in advance.

[v-lili6-msft]

hi  @Anonymous 

You need load the the table which contains ROWID field into power bi, then you could use it in powerBI relations

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

Regards,

Lin

[Anonymous]

 SQLite ROWID column 

In SQLite, table rows normally have a 64-bit signed integer ROWID which is unique among all rows in the same table

Example:

CREATE TABLE "AREA_DEFINITION" (
"AREA" INT,
"TYPE" INT NOT NULL,
"DATETIME" TEXT NOT NULL,
PRIMARY KEY("TYPE")
);

select ROWID from AREA_DEFINITION;

CREATE TABLE "AREA" (
"AREA" INT,
"DATETIME" TEXT NOT NULL,
FOREIGN KEY("AREA") REFERENCES "ATTRIBUTE_DEFINITION"("ROWID")
PRIMARY KEY("AREA")
);

But when load all the table in PowerBI apper errors

ROWID