"Showing All Tables May Cause Slowdowns"

[RayDK]

Hello PBI experts! Have any of you seen a warning like this? I'm being asked to create a data model with a large number of tables, and seeing a warning about slowdowns.

If anyone has links to official documentation on what triggers this warning, limits on number of tables, or anything else related, that would be extremely helpful. I need to either demonstrate to my team lead that this warning isn't a result of user error on my part--or fix the error if I'm making one! (Just to be clear, the number of tables is specified in the project requirements--the concern is that I'm doing something wrong other than bringing in a lot of tables.)

[lbendlin · Accepted solution]

The warning points out that the rendering of the tables and their relationships in the model view may be delayed/slowed/jerky.

Without seeing your actual data model it is also worth pointing out that the more tables you have the higher the chances of the expanded tables growing out of control.  Again - this is not a given, but certainly an (increased) possibility. Keep in mind that under the hood you are still dealing with cartesian products.