Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
smpa01
Super User
Super User

Does primary/foreign key through datamart get carried over to AZURE SQL

If I ingest my data in a datamart and use Table.AddKey to specify primary/foreign keys in the table,

does the key get carried over to the SQL view that I can access on the AZURE SQL db?

 

The tables ingested in datamart create views on the db and hence, scopes are limited to creating any implicit index. But if I can ensure that the keys are getting carried over, I can ensure some performance optimization.

 

@TomMartens 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
1 REPLY 1
Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

@smpa01 - Hi Tom, I see where you are going with this, but I guess it will be a limitation of the Views in the SQL DB.  Power BI can see the Foreign and Primary keys because of the metadata relationship tables that created.  Otherwise Power BI would not or would guess the key from the Model.Views.  

If you are trying to import the Datamart in Azure DB (i.e. not Power BI), then the developer of the Azure Sql would need equivalent metadata object to use a guide to understanding the model views??

DarylLynchBzy_0-1655316427240.png

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors