Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How many inactive relationships can you have before you notice a significant performance impact? I have a table with 260 different date columns. That means I would have 259 inactive relationships and 1 active relationship ... and that is just one table of many that would be part of the PBI document.
I haven't seen any limitation about this. But you might select Unpivot Columns for those date columns in Query Editor.
I unpivoted the columns using SQL, but my DB guys are saying that's not a good idea. I wanted to double check implications of doing it their way 259 inactive relationships before we had a debate about it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |