AnMatt2891
4 months agoNew Member
Status:
New
PowerTable: Reference Columns need dropdown support for new record creation (Insert Row and Forms)
Product: Fabric IQ Plan (preview); PowerTable sheets Context: Built a complete EPM proof-of-concept for budget planning global offices: Fabric SQL Database (star schema with fact + dimension tables)...
aven1912
2 months agoRegular Visitor
I believe this scenario is already supported today through Lookup Columns. If you have a RegionCode stored in your database and a corresponding display label column (for example, USA) in the same table or a related lookup table, you can configure the ID column to display the label while persisting the underlying key value during save operations. To do this: Go to Manage Columns and edit the target ID column (e.g., RegionCode). Set Input Type to Single Select. Set Values Type to Lookup. Select the appropriate Lookup Schema and Lookup Table. Configure: Lookup Key Column = RegionCode Lookup Display Column = Region With this configuration, users will see and select friendly labels such as USA, while the corresponding region code is stored in the database when the record is saved. If the requirement is simply to expose the underlying key alongside the label for transparency when you are inserting a new Row and assigning a Region for it, that can also be achieved today by adding a Formula Column: Insert a new Formula Column (e.g., simply name Region Code (Read Only Purpose)). Set the formula to: [RegionCode] from the formula reference dropdown list Leave Create Database Column unchecked so that the column is used purely for display purposes. This gives users a read-only column showing the actual stored key while still allowing them to work with user-friendly labels in the lookup dropdown column. This should address the need to display both the friendly label and the underlying code without requiring users to enter or memorize key values.
Recent ideas
Data Pipelines - Run only selected activities
For debugging and testing pipeline activities during development, allow us to select one or multiple activities and run only the selected pipeline activities. For example, I'm working on editing ...frithjof_v17 hours agoCommunity ChampionNew618Views11likes2CommentsSemantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v1 day agoCommunity ChampionNew20Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal1401971 day agoFrequent VisitorNew6Views0likes0Comments