Load to Data Model Failed

[Tica]

Hi,

Anyone can assist me on the issue of my power query has a problem about "Load to Data Model Failed" The query shows that:

"The Data Model table couldn't be refreshed:
Exception has been thrown by the target of an invocation."

I am not sure is my data too loaded or other problem but my data couldn't update when i refresh all data.

 

[Chihiro]

What version of Excel are you using (2010, 2013, 2016, Office 365 etc) and what build?

And where are you refreshing data from? (On loaded pivot table, Power Pivot window, etc)?

Give as much details as you can, since that error can be caused by several different things.

 

[GraH - Guido]

There is a known bug since a couple of weeks where (even small) data cannot be loaded from PQ to PP.
A workaround is importing the PQ in PP.
A reference https://answers.microsoft.com/en-us...-get-and/912d55f0-182e-4b84-a007-5db6c42cb82a.

 

[Chihiro]

FYI that's specific to Excel 2016 as far as I'm aware.

 

[GraH - Guido]

Had it on 365 also, but indeed v2016.