This topic contains 13 replies, has 2 voices, and was last updated by 
-
Posts
-
I created a data model using Power Query and Power Pivot in Excel 2013 when I went to open in Excel 2016 displays the following error message in the data update
“The query was not executed or the data model can not be accessed See the error message received:. An unexpected <span tabindex=”-1″ contenteditable=”false”>exception occurred</span>”
on my computer it works correctly, however other with Excel 2016 works notatt.
correct message
The query was not executed or the data model can not be accessed See the error message received:. An unexpected exception occurred
Hi,
Initial thoughts are that sometimes an individual workbook will be corrupted in the conversion process.
However, thinking again, maybe the issue is not corruption. Can you open the Power Pivot window in the workbook and locate a formula that has an error indicator next to it (either for a calculated column or a measure)?
When I started using Excel 2016, one of the issues that I encountered using data models that worked well in 2013 was that my dates table was often named Calendar which became a keyword in Excel 2016 and therefore needed to be delimited with single quotation marks to consistently work as expected.
The above paragraph may not be the case for you, but let me know if the Power Pivot window is at least accessible and whether any of the formulas have an error indicator next to them.
Tom
Tom,
The problem is that, when you open the spreadsheet, and begins to update the queries, displays the error message and Excel is locked.
I have disabled the update of the tables in the opening, not error
I activated the update just the fact query, not error
I activated the update a fact query and a dimension, in error
no formula has error
att.
Rogerio
Tom,
we perform the test on 2 computers in the office with Excel 2016 opens ok
we perform the test on 2 computers in the client with Excel 2016 error opening
att.
Rogerio
How many fact tables does your model have?
Tom,
only one
link workbook = https://1drv.ms/f/s!Au1L5zHi1GMNkkt4GH2CUrIO9Tnn
Restore em C:\
att,
Rogerio
Rogerio,
Can you put files in a zip and not a rar?
Tom
Tom,
if I take the formulas to send me opens ok
following formulas:Qtde Média:=AVERAGEX (
FILTER (
ADDCOLUMNS (
VALUES ( dimData[Month] );
“Monthly Sales”;
CALCULATE (
SUM ( fatPedidosGerencial[QtdeSolicitada] )
)
);
[Monthly Sales] > 0
);
[Monthly Sales]
)Venda Média:=AVERAGEX (
FILTER (
ADDCOLUMNS (
VALUES ( dimData[Month] );
“Monthly Sales R$”;
CALCULATE (
SUM ( fatPedidosGerencial[FVlrLiqTotal] )
)
);
[Monthly Sales R$] > 0
);
[Monthly Sales R$]
)att.
Rogerio
Rogerio,
I was able to open, refresh (multiple times) and interact with the workbooks without an error.
A couple of times I did receive warnings that the power pivot engine could not start a task while before it had finished whatever process it was currently working on, but I closed the workbook and re-opened without receiving the messages again.
I am running 64-bit professional plus edition of Excel 2016 for Office 365 (which, by definition of Office 365 has all service packs installed).
If changing the formulas makes the workbooks run better on your client machines, that is good. I think it might also be worth investigating which version (32 bit or 64) of Excel 2016 you clients were running. When I first tried extracting the files I was running up against some perceived security issues which I was able to resolve, so maybe there could have also been some security issues on the client machines.
Otherwise, everything worked for me.
Tom
Tom,
Customer is using the same version of Office ProPlus 365 – Excel 2016 64-bit
I even removed and installed again Office to take the test, and yet nothing
att.
the event viewer receive these messages
Can not find the description of the Event ID 22 at the origin “MSOLAP $ LocalCube”. The component that raises this event is not installed on the local computer or the installation is damaged. You can install or repair the component on the local computer.
Can not find the description of the Event ID 21 at the origin “MSOLAP $ LocalCube”. The component that raises this event is not installed on the local computer or the installation is damaged. You can install or repair the component on the local computer.
att
I am not familiar with the error messages, but the following link may help:
The forum ‘Power Pivot’ is closed to new topics and replies.