The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
@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??