Power Query load to data model

%3CLINGO-SUB%20id%3D%22lingo-sub-1611900%22%20slang%3D%22en-US%22%3EPower%20Query%20load%20to%20data%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1611900%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20query%20from%20various%20tables%20situated%20in%20the%20same%20workbook%2C%20non%20of%20which%20are%20connected%20to%20the%20data%20model.%20The%20query%20is%20not%20loaded%20to%20any%20table%2C%20it%60s%20sole%20purpose%20is%20to%20collect%20and%20sort%20data.%20I%20have%20added%20the%20query%20to%20the%20data%20model%20and%20established%20the%20required%20relations%2C%20but%20when%20I%20try%20to%20refresh%20power%20query%20the%20refresh%20hangs%2C%20I%20have%20cleared%20the%20Cache%2C%20reinstalled%20Office%2C%20remade%20the%20query%20to%20assure%20that%20there%20are%20no%20name%20or%20data%20conflicts%20but%20the%20problem%20persists.%20The%20only%20solution%20I%20found%20was%20to%20load%20the%20query%20to%20a%20sheet%20and%20load%20the%20corresponding%20table%20to%20the%20data%20model.%20I%20tried%20to%20load%20other%20queries%20directly%20to%20the%20data%20model%20and%20encountered%20the%20same%20problem.%20Am%20I%20experiencing%20some%20sort%20of%20problem%20or%20is%20just%20not%20possible%20to%20load%20a%20query%20directly%20to%20the%20data%20model%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612000%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20load%20to%20data%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612000%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F631240%22%20target%3D%22_blank%22%3E%40_Parjam_%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAre%20you%20on%20Excel%202016%3F%20It%20was%20similar%20bug%20on%20it%20some%20ago.%3C%2FP%3E%0A%3CP%3EIn%20general%20it%20shall%20work%2C%20that's%20one%20of%20the%20basis%20operations%20to%20load%20directly%20to%20data%20model.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612043%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20load%20to%20data%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612043%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%3BI%20am%20on%20the%20subscription%20365%20Business%20version%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612091%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20load%20to%20data%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612091%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F631240%22%20target%3D%22_blank%22%3E%40_Parjam_%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESomething%20is%20wrong%20in%20your%20environment.%20I'd%20suggest%20to%20Send%20a%20Frown%20from%20File-%26gt%3BFeedback.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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 data. I have added the query to the data model and established the required relations, but when I try to refresh power query the refresh hangs, I have cleared the Cache, reinstalled Office, remade the query to assure that there are no name or data conflicts but the problem persists. The only solution I found was to load the query to a sheet and load the corresponding table to the data model. I tried to load other queries directly to the data model and encountered the same problem. Am I experiencing some sort of problem or is just not possible to load a query directly to the data model? 

3 Replies
Highlighted

@_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.

Highlighted

@Sergei Baklan I am on the subscription 365 Business version

Highlighted

@_Parjam_ 

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