September 28, 2017 at 2:48 pm #8365
Is anyone else having issues with Version 1705 (Build 8201.2193)?
None of our users that updated recently can refresh the data model. Refresh of individual queries and refresh all both process indefinitely.
No issues refreshing in Version 1701 (Build 7766.2099).October 11, 2017 at 12:56 am #8407
Yes, I’m stuck too.
Processing time went from 10-15 minutes to 12-20 hours.
Any news on this ?October 11, 2017 at 1:05 am #8408
A new version “Version 1705 (Build 8201.2200) was just released (as of Oct 10 late PM).
I am trying it right now.October 11, 2017 at 1:45 pm #8410
New newer version did not work too.
I went back to the old version (June 2017 with updates) using the following command and my processing time is back to normal.
I don’t know how to get Microsoft in the loop about this major problem.
Command to revert to previous working version. Also, disable the update in excel
C:\Program Files\Common Files\microsoft shared\ClickToRun> OfficeC2RClient.exe /update user updatetoversion=16.0.7766.2119October 12, 2017 at 7:29 pm #8430
We also reverted – such a pain and very concerning.
We tried 1705 (Build 8201.2171) and Version 1708 (Build 8431.2079) with no success but have not tried Version 1705 (Build 8201.2200). Will give it a shot.
Thanks for jumping in the thread – misery loves companyOctober 13, 2017 at 1:56 am #8431
Do you have many (or large) linked tables in your model?
We have a number of linked tables, but the vast majority are not enabled for refresh all. One of them is massive at ~1M rows and 35 columns (not enabled for refresh all). A couple of smaller link-back tables are refreshed in refresh all though.
Linked / link-back tables have always seemed to be the most problematic/inconsistent for us (even in the “good” versions). Have been working towards replacing them all on a hunch that they may be the source of our new frustration.
Ran into the recent “where did my ‘linked tables’ tab go to?” thread and am taking it as a bit of validation (seems like they are changing the way these connections are handled). Could be totally off base, but no other leads to chase at this point.October 13, 2017 at 4:37 am #8436
Does the power pivot pro crew have any feedback here? Surely they’ve experienced issues with large and/or complex models on these new versions if we are?October 13, 2017 at 8:09 pm #8446
I have not one linked table anywhere in the workbook.
about 7 million rows in 50 tables.
Data only loaded to model, not to worksheet tables.October 17, 2017 at 4:07 pm #8477
A bit more info on my Power query queries:
- All Power query loads data only in the “Data Model”
- “Fast Data Load” option set to Enable
- Data sources are: REST api, MySQL queries, MySQL tables, Local Workbook tables
- The Model is a cripple Star Schema with basically 7 facts tables ~6M rows and 40 dimensions (most small except User dim > 1M)
I was looking at processexplorer call stack for Excel and the process seamed to be stuck in a recursive call of some calculation function.
The problem is directly linked with a code change the Excel team did if you ask me. Upgraded version: Problem appeared; Downgraded version: Problem disappeared.
This problem was entered here (powerpivotpro.com) and at the following two Microsoft sites:
So, we are not alone.
You must be logged in to reply to this topic.