Share via

PowerPivot is unable to load the Data Model

Anonymous
2023-01-31T12:41:34+00:00

Hi there,

When I try to add to add data model in power pivot. It shows this error in the screen shot (1, 2, 3)

-Initialization of the data source failed

-An issue with the Data Model is preventing Microsoft Excel from opening this workbook...

Also, on clicking the Manage Data Model or Add to Data Model under PowerPivot tab, it shows the screen shot (4)

-PowerPivot is unable to load the Data Model

Please assist.

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

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-01-31T13:16:56+00:00

    Hello,

    This is Jay Cee, I'll do my best to help you get the concern sorted, or direct you towards the solution needed.

    You may attempt to perform Online repair by following the steps below:

    On the Windows Start screen, type Control Panel. Click or tap Control Panel. Under Programs, click or tap Uninstall a program. Click or tap Microsoft Office Program installed in the PC, and then click or tap Change. Click or tap Online Repair, and then click or tap Repair. You may have to restart your computer after the repair process is complete.

    Please let me know if this helps.

    Regards,

    Jay Cee

    0 comments
  2. Anonymous
    2023-01-31T22:14:50+00:00

    Hi Jay Cee,

    Thanks for your response.

    Sorry I should have mentioned that I have done online repair too, but the issue persist.

    Any other way to solve the issue?

    Regards.

    0 comments
  3. Anonymous
    2023-02-01T04:17:26+00:00

    Hi,

    Thanks for that additional information. You're definitely on the right path of troubleshooting. Have you also tried reinstalling the Office app, just to further isolate the problem?

    Warm Regards, Jay Cee

    0 comments
  4. Anonymous
    2023-02-01T09:19:08+00:00

    Yes I did reinstall. I even tried downgrading to 2019. Same issue persist.

    I had to reinstall 2021, did online update again. Still not working!

    Image

    0 comments
  5. Anonymous
    2023-02-02T12:42:09+00:00

    Hello, I am Leonielhou, an Independent Advisor and a user like you, I am happy to help clarify any questions you may have.

    Contact your database administrator to see if they can assist with the issue.

    If the issue persists, create a new data source connection to the database and use that instead. If you are still encountering the errors, it may be due to corruption in the data model. Try repairing or recreating the data model.

    0 comments