question

AliSEMLALI-3549 avatar image
0 Votes"
AliSEMLALI-3549 asked VikiJi-MSFT commented

Power pivot/Power query doesn't work neither data models

hello, I have MSFT OFFICE 365 PRO PLUS entreprise : 16.0.11328.20362 and powerpivot does not work, it gives me errors, also the data model. Lots of error messages, I don't know what to do. I can't work for now .... PLEASE HELP.


141017-erreur3.png141135-erreu1.png141114-erreur4.png141102-excelprobleme.png141103-capture2.png


power-query-not-supportedoffice-excel-itpro
erreur3.png (195.1 KiB)
erreu1.png (173.6 KiB)
erreur4.png (197.4 KiB)
excelprobleme.png (196.6 KiB)
capture2.png (223.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

VikiJi-MSFT avatar image
0 Votes"
VikiJi-MSFT answered VikiJi-MSFT commented

Hi @AliSEMLALI-3549,
Welcome to Q&A forum!

According to the information you provided, I want to confirm the following information with you.

  • When did this issue start? What did you perform before this issue?

  • Can you open the Excel app and other Excel files normally? If this issue only occurs with a special file, how and where did you get it?

If it was created by an earlier version, it may be known issue, please refer to: Upgrade Power Pivot Data Models to Excel 2013 or Excel 2016.

If the issue persists, you can also try to delete the Data Model completely, and then try to recreate it to check whether the issue can be fixed:

  1. Close the file.

  2. Open this .xlsx file with your favorite compression software.

  3. Delete the "/xl/model" folder.

  4. Open Excel again, and you will see a prompt telling you that Excel needs to repair this file.

Note: Please back up the file before changing the file.

Any updates, please let me know.


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 7
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello,

The issue start when i want to add the file to the Data Model, it tells me that it's not possible, that there is a problem with the data model. And then when I start PWR PIVOT, It tells me the other errors. The errors is not related to the file because I've used several files, new files for test and the error is the same thing. I've changed my computer and I have the same error. the first error I had is this : Please Help

141415-erreur-aussi-sur-le-nouveau-poste.png


0 Votes 0 ·

Hi @AliSEMLALI-3549,
Thanks for your reply and sharing.
I tested it on the following version of Microsoft 365 for Apps, but it did not reproduce your problem.
141781-image.png
I noticed that your Office version is relatively old, please try to update your Office to the latest version to check this issue.
About Office update history, please refer to: Update history for Microsoft 365 Apps.

If the issue persists, when did the issue start? Have any installations or updates been performed before this issue?
Besides, I also suggest that you repair your Office to check this issue.
Any updates, please let me know.

0 Votes 0 ·
image.png (24.1 KiB)

Hi @AliSEMLALI-3549,
How is your issue going now?
Please feel free to post back any updates.
Thanks.

0 Votes 0 ·

Hi,

Unfortunately the same thing, the same errors. For example this morning, I want to use power query and load data on excel sheet but it cannot be done : ERROR as you can see in the picture below. I have contact IT of my company they told they are trying to contact Microsoft support for this as i'm doing right now. I don't konw what to do. It really blocks my work and I cannot do anything ...



[1]: /answers/storage/attachments/143300-capture.png

0 Votes 0 ·
capture.png (156.8 KiB)

Hi @AliSEMLALI-3549,
Thanks for your reply.
I think you could ask your IT to open a paid ticket with Microsoft support to help you test remotely and further analyze this issue.
Hope you can solve the issue as soon as possible.

0 Votes 0 ·

Hello,

There is the incident number : 2110250040004881 request by the IT...

0 Votes 0 ·

Hi @AliSEMLALI-3549,
Thanks for your reply and sharing.
If there are any updates, welcome to share with us.
Thanks.

0 Votes 0 ·