Dec 07 2019 11:55 AM
Hi i can't Load data on data Model please help.
Dec 07 2019 12:01 PM
I guess you are on Excel 2016 - this bug appears from time to time.
Dec 08 2019 12:57 AM
yes, any solution I updated excel 2016 but bug not fix@Sergei Baklan
Dec 08 2019 09:17 PM - edited Dec 08 2019 09:18 PM
@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.
:)
Dec 08 2019 09:23 PM
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?
Dec 08 2019 11:25 PM
@Wyn Hopkins , IMHO, any 2016 has data model. But not any has Power Pivot, only Pro versions.