It would be nice to have support for identity column in DDL for lakehouse
4 Comments
- KenVraagaardFrequent Visitor
Imo Lakehouse IDENTITY column ought to be on the roadmap already. Power BI best practice for semantic models is building dimensional models and using INTEGERS for surrogate keys, which thus lends further priority to IDENTITY column.
For me this also ties to Materialized Lake Views (MLVs), which only becomes fully useful for creation of a Kimball dimensional model if we have IDENTITY column and MERGE capabilities. Therefore, please also consider related idea: Materialized Lake Views (MLV) IDENTITY insert and MERGE would enable slowly changing dimensions | Microsoft Fabric Community.
- AnonymousNot applicableThis has been solved by Databricks already... so shouldn't be re-inventing the wheel here.
- fbcideas_migusrNew MemberStatus added:Under Review
- nishalitNew Member
We are evaluating this idea and its timeline along with other priorities. Your comments and votes will help us plan and design the feature. Thank you for your feedback!
Recent ideas
Need an option to save PBIP files without data (the .abf files)
We need an option to save the PBIP without saving the ABF file, just like the PBIT file is saved without data. As it is now, we will violate company security policies that don't allow storing data ...heve10 minutes agoNew MemberNew608Views39likes6CommentsiOS Shortcuts Support for Direct Access to Power BI Reports
We are looking to deploy several Power BI reports to support emergency response activities. The intended users are primarily non-technical staff who do not use Power BI currently, but who would benef...Default81293 hours agoFrequent VisitorNew3Views0likes0CommentsSupport Fabric Workspace Identity for custom APIs
Currently, Fabric Workspace Identity cannot be used to authenticate against custom APIs protected by Microsoft Entra ID. Azure Managed Identities support requesting an access token for a specific AP...frithjof_v6 hours agoCommunity ChampionNew62Views5likes0CommentsAllow the target pipeline reference in Invoke Pipeline / ExecutePipeline to be set dynamically
Problem Today, the Invoke Pipeline activity (and legacy ExecutePipeline) requires picking the target pipeline statically at design time — a fixed Workspace/Pipeline selection in the UI, which serial...JONATHANHAUN20 hours agoNew MemberNew8Views0likes0CommentsReset Bookmark Navigator Selection to the Default Published View on Browser Refresh
In Power BI Service, when a user selects a bookmark through a Bookmark Navigator, the bookmark identifier is appended to the report URL. If the user refreshes the browser page, the report reloads in ...vivek1234421 hours agoMicrosoft EmployeeNew6Views0likes0Comments