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
Access Variable Library in Semantic Models
Enable the Variable Library as a centralized location for storing all environment‑specific variables, allowing us to adjust them for promotion scenarios (e.g., from dev to prod) without relying on de...FreddyH3 hours agoAdvocate IINew910Views31likes2CommentsEnhance Fabric Pipeline Monitoring with Parent-Child Pipeline Lineage and Parameter Visibility
Currently, Microsoft Fabric Pipeline monitoring lacks several capabilities that are available in Azure Data Factory, making troubleshooting and operational support challenging in enterprise environme...dwramreddy3 hours agoRegular VisitorNew2Views0likes0CommentsDynamic ADLS-Gen2 path input for Spark Jobs Main definition file
I would like the ability to add a dynamic input box on a spark job definition's "Main Definition File" "ADLS-Gen2 path". this would be useful to set base and variable paths across all spark jobs...mfink_db8 hours agoNew MemberNew238Views2likes2CommentsReintroduce Tenant/Capacity Switch to Control "Users can create Plan items" Post-GA
During the Preview phase of Fabric Plan items, administrators had access to a dedicated tenant/capacity setting: "Users can create Plan items". With General Availability (GA), this granular administr...Sri-Surendra_Ku11 hours agoNew MemberNew106Views14likes1Comment