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
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

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