Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I am getting the error about about no matching columns when I add a column into a Matrix.
I ran a simple test where I have a master with 2 detail tables and have relationships from the master to each detail table.
1. I added one column from the detail A into an empty Matrix Visualization. No issues.
2. I add a column from the second detail table B and get the error about not being able to match the two columns.
If I change the relationships from Master to detailA and detail A to detail B then both detail columns can be added to the Matrix. Basically a daisy chain and not a star type schema that I need.
There must be something I am missing or the Model releationships are not what I expected.
Thanks!
Solved! Go to Solution.
@Anonymous
Drag a custom measure to Values and check query with Performance Analyzer.
@Anonymous
Drag a custom measure to Values and check query with Performance Analyzer.
@Anonymous
If you have this kind of relation. You must have Column from Master C table to have data from both detail table
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |