cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Use ROWID field of a Sqlite table in PowerBI

First connect powerBI whith sqlite database file here 

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

Thank you in advance.

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Use ROWID field of a Sqlite table in PowerBI

hi  @jandres 

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: Use ROWID field of a Sqlite table in PowerBI

 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

 

ROWIDROWID

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors