Kevin_Prough
3 years agoNew Member
Status:
New
Allow Multi field/column relationships to exist between different tables in Power BI Desktop
Basically, I am hoping for a way to allow a relationship to be created between two different tables that uses multiple columns to help get to a point of uniqueness (Similar to a multi field/column join in SQL). Currently, we can only select one option for merging and the best workaround is to merge columns in Power Query Editor until we get some messy (but workable) composite key. While this is an acceptable workaround, it isn't great in principle. Existing methods such as merging don't work in this instance given the quantity of data that would need to be brought in. Additionally, we cannot make the change in the source as that schema is not going to change for a relatively small number of problems.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Allow calls of Fabric SQL Database stored procedures from Data Warehouse
It would be great if there were a possibility to call a SQL Database stored procedures directly from a Data Warehouse stored procedures. A use case for this would be e.g. logging activities and even...Vojtech_Dolejsi4 hours agoNew MemberUnder Review2.9KViews13likes3CommentsAllow Data View access for tables sourced from external semantic models
When using DirectQuery for Power BI datasets or semantic model chaining, developers can use remote tables in DAX, relationships, and report visuals, but cannot inspect the underlying rows in Data Vie...kent_lewan14 hours agoNew MemberNew3Views0likes0CommentsDouble cost of licensing for admin users for Fabric Capacity Metrics
For our organization we have specific user accounts for admin work and normal accounts for normal work. We do have an F65 capacity, and for me my normal user account is licensed so I can create. I ...AaronGross14 hours agoNew MemberNew2Views1like0Comments