Forum Discussion
How many inactive relationships before unusable?
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.
2 Replies
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.
