Power BI On-Premise Data Gateway Error: DM_GWPipeline_Gateway_SpooledOperationMissing”,”parameters”:{},”details”:[],”exceptionCulprit”:1

10 Comments

1. 

   Ajay June 17, 2020 at 7:01 pm

   Thanks for posting this. This would certainly help in future.

   Reply
   1. 

      Gilbert Quevauvilliers June 18, 2020 at 10:15 am

      Thanks for the kind words Ajay

      Reply
2. 

   Brent July 22, 2020 at 2:11 am

   Appreciate you sharing this. We suffered a VMWare outage and now that my VM running the gateway is back up none of my PBI reports will refresh. Same error as you. Reinstalling the gateway software sounds easy – but not if I must rebuild all the data source definitions. What was your experience – did you rebuild the data sources or did they somehow remain intact on the reinstall?

   Reply
   1. 

      Gilbert Quevauvilliers July 22, 2020 at 8:34 am

      Hi there

      If you have a copy of the Power BI On-Premise Data Gateway recovery key, when you re-install you can opt in to put in the Recovery key, and all your data sources will be restored!

      Before you uninstall the Gateway make sure you got a valid Recovery key and you will be good to go!

      Reply
      1. 

         anders November 5, 2021 at 4:17 am

         how keys can be validated in order to be completely sure that you have a right recovery keys?;)

         Reply
         1. 

            Gilbert Quevauvilliers November 5, 2021 at 12:19 pm

            Hi Anders,

            I would suggest making sure you make a copy of the key when it gets created.

            Reply
3. 

   anders November 5, 2021 at 4:15 am

   hello Gilbert,

   is there any chance that this error could be related to performance issue?
   Moreover in conf file (Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.conf) there is an setting SpoolerOperationEvictionTimeout, is it somehow related?

   I have two Gateway setup in one cluster and there are some users who receiving such a error during refreshes, I am wondering how I could identify the real cause?

   Thank you for any answer and regards!

   Reply
   1. 

      Gilbert Quevauvilliers November 5, 2021 at 12:18 pm

      Hi Anders,

      I would suggest making sure that the hardware is the same on both servers.

      I would also make sure you have the diagnostic logging on the gateway servers to make sure that they are not overloaded?

      Here are more details: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance#performance-logging

      Reply
4. 

   Mark January 21, 2022 at 1:43 am

   Thanks! You confirmed my suspicions and saved the day!

   Reply
   1. 

      Gilbert Quevauvilliers January 21, 2022 at 9:07 am

      Hi Mark

      Thanks for the awesome comment, glad to hear it has helped you!

      Reply