Excel Power BI data connector (very slow)

[Jkaelin]

Good afternoon,

I have created a Power BI report and published it to my workspace.  I use the Power BI Publisher for Excel to connect to the data model.  However, selecting slicers & other items is extremely slow (20-30 secounds per change). 

Does anyone know if any performance tips or suggestions?  I couldn't find much reading other forums as there seems to be little on this topic.

Thank you!

James 

[Hakim]

Hi,

I'm also having this problem with my PBI data model when I connect to the Dataset from Excel.

Would really appreciate it if anyone can share their experience and how they manage it.

I think there are 2 issues which I have identified:

1. It always try to connect to the datasource and the timeout is quite short (around 15 min) and this always takes around 30 seconds
2. Whenever I try to pull down the slicer or add a new measure/Dimension to the pivot, the running OLAP query also takes 10-30 second (EVERYTIME) so it takes quite a bit of time to create report that I need.

[v-juanli-msft]

Hi @Jkaelin

How about the size of your pbix file?

As i known, if your pbix is large or has a complex model, it may be slow when interactiving.

From the view of Power BI, I would like to recommend you to read this article about how to build fast and reliable reports in Power BI.

Additionally, I have found an article how to get data from Power BI into an excel table with better performance.

Hope these all give some helpful ideas.

Best Regards

Maggie

[Jkaelin]

The size of the .pbix file is 192mb.  The model is based off of "PowerPivotPro" and their cascading income statement data model.  So it's not the perfect star model but I'm not under the impression it's poorly modeled.  

Thank you for the two articles.  I guess I'm in a conundrum because it doesn't seem many other users experience this type of poor performance.  Maybe my model is too big?  It's got two fact tables of 7M records & another 3M records.

Thank you,