Forum Discussion

_Parjam_'s avatar
_Parjam_
Copper Contributor
Aug 25, 2020

Power Query load to data model

I have created a query from various tables situated in the same workbook, non of which are connected to the data model. The query is not loaded to any table, it`s sole purpose is to collect and sort ...
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 25, 2020

_Parjam_ 

Are you on Excel 2016? It was similar bug on it some ago.

In general it shall work, that's one of the basis operations to load directly to data model.

  • _Parjam_'s avatar
    _Parjam_
    Copper Contributor
    Aug 25, 2020

    SergeiBaklan I am on the subscription 365 Business version

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Aug 25, 2020

      _Parjam_ 

      Something is wrong in your environment. I'd suggest to Send a Frown from File->Feedback.