Forum Discussion
Model update time PIVOT power is high
Regards I require your support with Power PIVOT. It turns out that I have 7 different tables from a connection to SQL from power query and that will eventually become a SINGLE DATA SOURCE. this F...
Hello - there are many, many reasons why this could be happening (too many fields in the table, poorly designed models, inefficient measures, etc). I recommend starting with data modeling best practices for Power Pivot and PowerBI. There are a lot of articles that address this topic. Here is one website that particularly focuses on Power Pivot.
https://p3adaptive.com/2016/02/data-modeling-power-pivot-power-bi/