Home

Data Model/Power Query Error

%3CLINGO-SUB%20id%3D%22lingo-sub-255307%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Model%2FPower%20Query%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-255307%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergei%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECool%2C%20thanks%20for%20the%20help!%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20gonna%20send%20this%20file%20to%20my%20IT%20department%20'cause%20I%20don't%20have%20the%26nbsp%3Bprivileges%20for%20making%20that%20change%20...%20%3A(%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251567%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Model%2FPower%20Query%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251567%22%20slang%3D%22en-US%22%3E%3CP%3EOn%20the%20forums%20people%20say%20that's%20due%20to%20antivirus%2C%20in%20particular%20Trend%20Micro%20Officescan.%20Try%20to%20disable%20it%20for%20a%20while%20and%20check%20if%20helps.%26nbsp%3BFor%20example%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Fen-US%2F4dbd3e1c-9b6d-4f16-a30a-d75429aaefd2%2Fpower-pivotpower-query-error-message%3Fforum%3DOffice2016ITPro%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Fen-US%2F4dbd3e1c-9b6d-4f16-a30a-d75429aaefd2%2Fpower-pivotpower-query-error-message%3Fforum%3DOffice2016ITPro%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fforum.powerpivotpro.com%2Fforums%2Ftopic%2Fpower-pivot-refresh-error%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fforum.powerpivotpro.com%2Fforums%2Ftopic%2Fpower-pivot-refresh-error%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3Eand%20some%20other%2C%20you%20may%20google%20for%20more.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251472%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Model%2FPower%20Query%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251472%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jeremy%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20same%20problem%2C%20did%20you%20find%20a%20way%20to%20solve%20it%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3EBest%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-206726%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Model%2FPower%20Query%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-206726%22%20slang%3D%22en-US%22%3E%3CP%3Ethis%20is%20also%20happening%20to%20me....%26nbsp%3B%20Did%20you%20solve%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-660834%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Model%2FPower%20Query%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-660834%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20my%20case%20it%20turned%20out%20to%20be%20Teams.%26nbsp%3B%20Once%20I%20unloaded%20Teams%2C%20the%20problem%20went%20away.%26nbsp%3B%20I%20read%20several%20articles%20that%20said%20it%20was%20antivirus%2C%20blocked%20files%2C%20need%20to%20reboot....but%20in%20the%20end%20the%20only%20thing%20that%20caused%20and%20cured%20the%20problem%20was%20having%20Teams%20running.%26nbsp%3B%20Once%20I%20shut%20that%20down%2C%20it%20worked%20like%20a%20champ.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-660913%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Model%2FPower%20Query%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-660913%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320366%22%20target%3D%22_blank%22%3E%40LloydWitt%3C%2FA%3E%26nbsp%3B%2C%20thanks%20for%20the%20sharing.%20Never%20heard%20Teams%20causes%20such%20conflict%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-690646%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Model%2FPower%20Query%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-690646%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320366%22%20target%3D%22_blank%22%3E%40LloydWitt%3C%2FA%3E!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20was%20exactly%20my%20problem!!!%26nbsp%3B%20You're%20a%20lifesaver!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-172160%22%20slang%3D%22en-US%22%3EData%20Model%2FPower%20Query%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-172160%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20running%20a%20Power%20Pivot%2FPower%20Query%20in%20Microsoft%20Excel%202016%2F365%2C%20I%20run%20into%20the%20this%20error%20below%3A%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%22The%20requested%20operation%20cannot%20be%20performed%20on%20a%20file%20with%20a%20user-mapped%20section%20open.%22%20(Attached%20is%20a%20screenshot%20of%20the%20error%20I%20see)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20I%20add%20the%20Power%20Query%20data%20to%20a%20table%20in%20Excel%2C%20I%20do%20not%20see%20this%20error%2C%20but%20when%20I%20try%20to%20add%20the%20data%20to%20the%20Data%20Model%2C%20this%20error%20appears.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20error%20also%20appears%20when%20I%20try%20to%20add%20data%20to%20the%20data%20model%20from%20Access.%26nbsp%3B%20I%20have%20tried%20disabling%20the%20.CUB%20and%20.XML%20from%20my%20anti%20virus%2C%20but%20I%20still%20get%20this%20error.%3C%2FP%3E%0A%3CP%3EI%20tried%20adding%20an%20screenshot%20to%20this%20question%2C%20but%20it%20will%20not%20let%20me.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-172160%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Jeremy Warren
Occasional Visitor

When running a Power Pivot/Power Query in Microsoft Excel 2016/365, I run into the this error below: 

 

"The requested operation cannot be performed on a file with a user-mapped section open." (Attached is a screenshot of the error I see)

 

When I add the Power Query data to a table in Excel, I do not see this error, but when I try to add the data to the Data Model, this error appears.  

 

This error also appears when I try to add data to the data model from Access.  I have tried disabling the .CUB and .XML from my anti virus, but I still get this error.

I tried adding an screenshot to this question, but it will not let me.

 

Thank you

7 Replies

this is also happening to me....  Did you solve it?

Hi Jeremy, 

I have the same problem, did you find a way to solve it? 

 

Thanks!

Best, 

 

 

On the forums people say that's due to antivirus, in particular Trend Micro Officescan. Try to disable it for a while and check if helps. For example

https://social.technet.microsoft.com/Forums/en-US/4dbd3e1c-9b6d-4f16-a30a-d75429aaefd2/power-pivotpo...

https://forum.powerpivotpro.com/forums/topic/power-pivot-refresh-error/

and some other, you may google for more.

Hi Sergei, 

 

Cool, thanks for the help! 

I'm gonna send this file to my IT department 'cause I don't have the privileges for making that change ... :( 

Best, 

In my case it turned out to be Teams.  Once I unloaded Teams, the problem went away.  I read several articles that said it was antivirus, blocked files, need to reboot....but in the end the only thing that caused and cured the problem was having Teams running.  Once I shut that down, it worked like a champ.

@LloydWitt , thanks for the sharing. Never heard Teams causes such conflict 

Thanks @LloydWitt!!!

 

This was exactly my problem!!!  You're a lifesaver!!

Related Conversations