First connect powerBI whith sqlite database file here
But How can I use ROWID field into my powerBI relations?
Thank you in advance.
You need load the the table which contains ROWID field into power bi, then you could use it in powerBI relations
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
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
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.