Power BI On-Premise Data Gateway Error: DM_GWPipeline_Gateway_SpooledOperationMissing”,”parameters”:{},”details”:[],”exceptionCulprit”:1
I got the following error DM_GWPipeline_Gateway_SpooledOperationMissing”,”parameters”:{},”details”:[],”exceptionCulprit”:1
This error was caused because the current Virtual machine where the On-Premise Data Gateway was running was cloned and then started up.
The result was that this then caused the Power BI Service to not correctly connect to the valid Gateway. The reason is that there were 2 servers running, with the same name, same configuration and same software installed.
In order to solve this, I had to uninstall the On-Premise Data Gateway on the new server.
Then re-install the On-Premise Data Gateway on the new server.
I also went into the Power Platform Admin center and made sure that the Gateway had the correct details as shown below.
My final step was to then test and refresh the dataset and it refreshed successfully.
Summary
I hope that this will assist others in finding an issue with their On-Premise Data Gateway. It did take me quite a while to figure this solution. Hopefully this will assist others if they run into this issue.
As always thanks for reading, if there are any comments please leave them in the section below.
Thanks for posting this. This would certainly help in future.
Thanks for the kind words Ajay
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?
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!