Home

data Loading on data Model

%3CLINGO-SUB%20id%3D%22lingo-sub-1054286%22%20slang%3D%22en-US%22%3Edata%20Loading%20on%20data%20Model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054286%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20i%20can't%20Load%20data%20on%20data%20Model%20please%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F160557i687917E16F5D53A1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1054286%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1054299%22%20slang%3D%22en-US%22%3ERe%3A%20data%20Loading%20on%20data%20Model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054299%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359821%22%20target%3D%22_blank%22%3E%40KAMLESH_JANGIR%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20you%20are%20on%20Excel%202016%20-%20this%20bug%20appears%20from%20time%20to%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1054540%22%20slang%3D%22en-US%22%3ERe%3A%20data%20Loading%20on%20data%20Model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054540%22%20slang%3D%22en-US%22%3E%3CP%3Eyes%2C%20any%20solution%20I%20updated%20excel%202016%20but%20bug%20not%20fix%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055087%22%20slang%3D%22en-US%22%3ERe%3A%20data%20Loading%20on%20data%20Model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055087%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359821%22%20target%3D%22_blank%22%3E%40KAMLESH_JANGIR%3C%2FA%3E%26nbsp%3BHi%2C%20right%20click%20to%20edit%20query%2C%20check%20if%20there%20are%20any%20changes%20in%20the%20steps%20since.%3C%2FP%3E%3CP%3EIf%20you%20were%20on%20a%20different%20computer%20check%20that%20any%20source%20is%20updated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20try%20replicating%20the%20query%20and%20run%20the%20second%20query.%20It%20worked%20for%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELastly%2C%20check%20that%20when%20you%20close%20the%20query%2C%20close%20%26amp%3B%20load%20to%20a%20new%20worksheet.%3C%2FP%3E%3CP%3E%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055099%22%20slang%3D%22en-US%22%3ERe%3A%20data%20Loading%20on%20data%20Model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055099%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359821%22%20target%3D%22_blank%22%3E%40KAMLESH_JANGIR%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20all%20versions%20of%20Excel%202016%20had%20the%20data%20model%20(Power%20Pivot)%20available%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20you%20confirm%20what%20version%20of%20Excel%20you%20have%2C%26nbsp%3B%20and%20whether%20you%20are%20able%20to%20go%20to%20File%20Options%20Add-ins%20select%20Com%20Addins%20and%20see%20if%20Power%20Pivot%20is%20available%20and%20ticked%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055179%22%20slang%3D%22en-US%22%3ERe%3A%20data%20Loading%20on%20data%20Model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055179%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%2C%20IMHO%2C%20any%202016%20has%20data%20model.%20But%20not%20any%20has%20Power%20Pivot%2C%20only%20Pro%20versions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055182%22%20slang%3D%22en-US%22%3ERe%3A%20data%20Loading%20on%20data%20Model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055182%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BAgree.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055183%22%20slang%3D%22en-US%22%3ERe%3A%20data%20Loading%20on%20data%20Model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055183%22%20slang%3D%22en-US%22%3EYep%2C%20quite%20right.%20Good%20call%20Sergei%3C%2FLINGO-BODY%3E
Highlighted
KAMLESH_JANGIR
New Contributor

Hi i can't Load data on data Model please help.

 

clipboard_image_0.png

7 Replies

@KAMLESH_JANGIR 

I guess you are on Excel 2016 - this bug appears from time to time.

yes, any solution I updated excel 2016 but bug not fix@Sergei Baklan 

@KAMLESH_JANGIR Hi, right click to edit query, check if there are any changes in the steps since.

If you were on a different computer check that any source is updated.

 

You can try replicating the query and run the second query. It worked for me.

 

Lastly, check that when you close the query, close & load to a new worksheet.

Hi @KAMLESH_JANGIR 

 

Not all versions of Excel 2016 had the data model (Power Pivot) available

 

Can you confirm what version of Excel you have,  and whether you are able to go to File Options Add-ins select Com Addins and see if Power Pivot is available and ticked?

 

@Wyn Hopkins , IMHO, any 2016 has data model. But not any has Power Pivot, only Pro versions.

@Sergei Baklan Agree. 

Yep, quite right. Good call Sergei
Related Conversations
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Forms will not load for all
BrandonJones in Microsoft Forms on
3 Replies
I have a challenging excel problem
Lyle Lazarus in Excel on
2 Replies
How often the sync is triggered?
HotCakeX in Discussions on
5 Replies
Maps Data for Scotland
Chris Nicol in Excel on
19 Replies