How many inactive relationships before unusable?

[kevlarmpowered]

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.  

[v-chuncz-msft]

@kevlarmpowered,

I haven't seen any limitation about this. But you might select Unpivot Columns for those date columns in Query Editor.

[kevlarmpowered]

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.