Forum Discussion

Fcalderara1984's avatar
Fcalderara1984
Regular Visitor
6 years ago

Slow Model with Sharepoint

Hi Everyone!

 

I been having some issues in the last weeks with a model that extracts data from differents sharepoint (all of the same company). They are mostly excel's files (office 365 versions) and i cant know why sudendly go really slow, a mean it consume all the RAM.

 

The performance analisys shows that the issue isn't in the DAX or Visualization, or the internet (cable conect to 600 mbps)

I think that the problem might be the number of querys (are 150 now), but the model is so slow that i couln't enter Power Query to disable some of the connections..

 

Please Help!!

 

I already see the Marco Russo video for slow models with DAX Studio Analisys and didn't see where is the problem, beacause it works fine a couple of weeks ago.

 

Thanks!!

2 Replies