I would love to be able to make relationships between tables by two columns.
For a simple example being able to make a relationship between Year and Month between two tables. This would allow it to be a one to many or one to one relationship rather than creating whole new table through a merge to be able to do this.
*I know this is an easy work around with a date column but other key columns are not easily fixed in that sort of way.
It would be similar to joining two tables in SQL ON two columns.
table1.Year = table2.Year AND table1.Month = table2.Month
This would instead define the relationship between two tables in PowerBI.
Maybe be able to hit ctrl, select two columns and drag them to another table to build that relationship in a similar manner as a relationship is made right now.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Native Master Data Management Solution
Microsoft Fabric currently lacks a native Master Data Management (MDM) capability, creating a gap for organizations that need to manage and govern business-critical reference data such as customers, ...bradcoles19 minutes agoRegular VisitorNew210Views1like3CommentsCopy results as markdown from data grid
When copying results from a query on the SQL Endpoint or Data Warehouse I often have to convert from the tab delimited table to markdown for sharing the results via services like teams or github. It...Tom_Fosterbi57 minutes agoRegular VisitorNew2Views0likes0CommentsDeployment Pipelines - Remember selected stage
Every time we go into a deployment pipeline, it defaults to selecting the Development stage. I believe that it would be very rare to have a user select the Development stage. It would be helpful if d...PeterDaniels8 hours agoAdvocate IINew1View1like0CommentsDisable auto-restore previous session's tabs in new Fabric sessions
Description: Since a recent update, starting a new Fabric session — for example by opening Fabric in a new browser tab — automatically reopens all the item tabs that were left open from a previous s...MathieuVr15 hours agoFrequent VisitorNew58Views5likes1Comment