cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kevlarmpowered Regular Visitor
Regular Visitor

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 2
Community Support
Community Support

Re: How many inactive relationships before unusable?

@kevlarmpowered,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kevlarmpowered Regular Visitor
Regular Visitor

Re: How many inactive relationships before unusable?

 

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.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors