Fix: We couldn’t load the data model on Windows 10
Certain older software might have few issues on Windows 10, and one of these issues is “We couldn’t load the data model” error. This issue isn’t a serious one, and it can be easily resolved by using one of our solutions.
Fix We couldn’t load the data model error on Windows 10
Solution 1 – Change Local Group Policy settings
According to the users, this error appears while trying to open PowerPivot for Excel 2013 Manage window. It seems that users don’t have enough privileges to use certain policies, so in order to fix this, we need to change Local Group Policy settings. To do that, follow these steps:
- Press Windows Key + R and type gpedit.msc. Press Enter or click OK to run it.
- Once Local Group Policy Editor opens, you need to navigate to the following in left pane:
- Locate Increase a process working set Policy and double click it.
- A list will appear in a new window. This list should include Users group, but if for some reason Users group isn’t on the list, click the Add User or Group button.
- In Enter the object names to select enter Users and click Check Names and OK.
- Users group should be now added. Click Apply and OK to save changes.
Solution 2 – Turn off SQL Server Analysis Services (Tabular) services
Users reported that “We couldn’t load the data model” error message appears when creating new Excel 2013 workbook and adding a table into Data Model. This can be an annoying problem, but fortunately there’s a solution available. In order to fix this problem, users advise to turn off SQL Server Analysis Services (Tabular) services. After turning these services off, the problem with “We couldn’t load the data model” message should be resolved.
Some users are suggesting to remove Analysis Services 2012 completely from your computer, so you might want to try that as well.
“We couldn’t load the data model” error message usually affects PowerPivot for Excel 2013, and as you can see, it can be easily fixed by using one of our solutions.
In case you’ve ever asked yourself the question Why won’t my printer print all pages, you came to the right place. It is extremely annoying […]
Microsoft rolled out a new Windows 10 cumulative update to Insiders for testing purposes. KB4505903 takes the Windows 10 build number to 18362.263. This time, […]
Two of the fixes made in version 20H1 were back-ported by Microsoft to version 1903 (Release Preview, build 18362.263). The first fix is about an […]