Data model does not refresh in Sharepoint

[Imi_Jay]

Hi there,

I have an Excel sheet,where data source is in the same Excel. It is stored in sharepoint. Data was taken from the table range and modelled in the PQuery. 

The aim was to whenever a change is made in the data source it should be loaded into 2 different sheets through PQuery.

When I hit refresh I end up getting an error message that data model cannot be refreshed. It works fine when I open it in app.

I am using Microsoft 365 -64-bit.

Thanks!

[#2 · Accepted solution]

@Imi_Jay 

It looks like at least one of queries loads data not only to sheet but to data model as well. Excel for web so far doesn't support data model. If you don't need it just uncheck for queries in Load To loading to data model.