The data model is not updated

%3CLINGO-SUB%20id%3D%22lingo-sub-1263658%22%20slang%3D%22en-US%22%3EThe%20data%20model%20is%20not%20updated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1263658%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWell%20there%20goes%20my%20first%20post%20on%20the%20forum.%3C%2FP%3E%3CP%3EI%20have%20a%20simple%20data%20model%20where%20I%20load%20sheet-based%20queries%20from%20other%20excel%20workbooks%20(I%20get%20data%20from%20an%20excel%20file%2C%20load%20it%20on%20a%20workbook%20sheet%20and%20pass%20it%20to%20Power%20Pivot%20data%20model%20where%20I%20generate%20measured%20relationships%20etc.)%20I%20use%20this%20data%20model%20to%20build%20a%20dashboard%20with%20dynamic%20charts.%20Suddenly%2C%20one%20of%20those%20queries%20has%20stopped%20updating%20in%20the%20data%20model%2C%20that%20is%2C%20I%20make%20a%20change%20in%20the%20original%20sheet%20and%20the%20query%20is%20updated%20correctly%20in%20Power%20Query%2C%20but%20when%20loading%20it%20in%20the%20sheet%20the%20data%20is%20not%20updated%20and%20therefore%20%2C%20neither%20does%20the%20Power%20Pivot%20data%20model.%3C%2FP%3E%3CP%3EI've%20thought%20about%20it%20a%20thousand%20times%20and%20I%20don't%20know%20where%20to%20look.%20The%20only%20thing%20I%20have%20left%20is%20to%20do%20it%20all%20over%20again%20but%20it%20is%20a%20great%20job%20and%20I%20wanted%20to%20see%20if%20anyone%20could%20give%20me%20any%20idea.%3C%2FP%3E%3CP%3EOn%20the%20way%20and%20if%20possible%2C%20I%20would%20appreciate%20understanding%20this%20process%20a%20little%20more%3A%20I%20create%20a%20query%20from%20another%20excel%2C%20I%20load%20it%20on%20a%20sheet%20of%20the%20new%20excel%2C%20I%20add%20it%20to%20the%20data%20model%20and%20build%20a%20graph%20on%20it%3A%3C%2FP%3E%3CP%3E-%20Is%20all%20this%20process%20necessary%3F%3C%2FP%3E%3CP%3E-%20Should%20I%20keep%20the%20query%20and%20the%20sheet%20in%20excel%20if%20I'm%20only%20going%20to%20use%20the%20data%20model%3F%3C%2FP%3E%3CP%3E-%20Where%20is%20the%20code%20that%20relates%20the%20data%20model%20with%20the%20query%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1263658%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1267773%22%20slang%3D%22en-US%22%3ERe%3A%20The%20data%20model%20is%20not%20updated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1267773%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F600474%22%20target%3D%22_blank%22%3E%40aleonc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20shouldn't%20be%20problem%2C%20once%20your%20refresh%20you%20query%20it%20should%20work%20with%20no%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20attached%20the%20file%20to%20see%20exactly%20what%20is%20happening%20%26amp%3B%20advise%20you%20the%20correct%20solution.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Highlighted
Regular Visitor

 

Well there goes my first post on the forum.

I have a simple data model where I load sheet-based queries from other excel workbooks (I get data from an excel file, load it on a workbook sheet and pass it to Power Pivot data model where I generate measured relationships etc.) I use this data model to build a dashboard with dynamic charts. Suddenly, one of those queries has stopped updating in the data model, that is, I make a change in the original sheet and the query is updated correctly in Power Query, but when loading it in the sheet the data is not updated and therefore , neither does the Power Pivot data model.

I've thought about it a thousand times and I don't know where to look. The only thing I have left is to do it all over again but it is a great job and I wanted to see if anyone could give me any idea.

On the way and if possible, I would appreciate understanding this process a little more: I create a query from another excel, I load it on a sheet of the new excel, I add it to the data model and build a graph on it:

- Is all this process necessary?

- Should I keep the query and the sheet in excel if I'm only going to use the data model?

- Where is the code that relates the data model with the query?

 

Thank you!

1 Reply
Highlighted

Hi @aleonc 

 

It shouldn't be problem, once your refresh you query it should work with no issue.

 

please attached the file to see exactly what is happening & advise you the correct solution. 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.