Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
First connect powerBI whith sqlite database file here
But How can I use ROWID field into my powerBI relations?
Thank you in advance.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |