Forum Discussion
Solved
Data model does not refresh in Sharepoint
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 ch...
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.
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.