Share via

Error: 'Power Pivot is unable to load the Data Model'

Anonymous
2021-05-14T07:48:18+00:00

Hello! I am working with Microsoft 365,my Excel version is 16.0.13127.21624 64-bit.

When I tried to upload data to Data Model, I was not able to create the connection, and the option for adding data to the data model was disabled.

Also, I got this error. So, Power pivot is not working for me.

Any tip?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-05-17T09:47:57+00:00

    Hi Muhammad!

    Thanks for your reply, however following the thread you sent onto me, the solution was to get ride off the Data Model, and I do want to keep my Data Model, and building relations with several queries.

    I enclosed my account for your reference.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2021-05-19T19:36:08+00:00

    Hi Enrique_TE,

    Have you checked above reply? Do you need further assistance?

    Best Regards

    Waqas Muhammad

    Was this answer helpful?

    0 comments
  3. Anonymous
    2021-05-18T12:31:35+00:00

    Hi Enrique_TE,

    Thanks for sharing updates with us. First of all please try to updates your Office version into latest version .The latest version is 2008(13127.21624. Also could you please confirm from what data source you are using to upload a Data model via go to Data tab in Excel. If you don't mind could you please share with us your steps and I will test on my side and verify the result with you. 

    I appreciate your patience and understanding.

    Best Regards

    Waqas Muhammad

    Was this answer helpful?

    0 comments
  4. Anonymous
    2021-05-15T06:27:28+00:00

    Hi Enrique_TE,

    Feel free to post back if you need further assistance.

    Best Regards,

    Waqas Muhammad

    Was this answer helpful?

    0 comments
  5. Anonymous
    2021-05-14T09:34:39+00:00

    Hi Enrique_TE,

    I go through your post carefully and as per your description, I'd like to confirm from what data source you encounter the issue? Does the issue happen when you get and load some data from some specific sources?

    Meanwhile, upload a full screenshot of the Account page in the Excel application you are using for our reference. You can access the page via clicking on File>Account.

    Note: Remove any private information before uploading the screenshots.

    If you don’t mind for test purpose, do on other computers with the same version number of the Office applications to see if the issue happens in your environment as well.

    Meanwhile, I would suggest you check methods from the thread: "PowerPivot is unable to load the Data Model" in Excel 2016 and Windows 10

    • close the xlsx in question
    • open the xlsx with favorite zip tool (i used 7zip)
    • delete the "/xl/model" folder
    • open xlsx with Excel again and respond to prompts that Excel needs to make repairs to the file
    • and that was it

    I appreciate your patience and understanding.

    Best Regards

    Waqas Muhammad

    Was this answer helpful?

    0 comments