Data Refresh to Power BI server failing.

[Missy_Perry]

Hello,

This is my 3rd time today with different datasets that are up on our Power BI server that keep failing.  They all give this error. But I am not sure what it means. They are all different datasets and different visuals. Anyone know what the error means? I can use Power BI Desktop and refresh the data there, save, and republish to the server, then the data is refreshed.  But the auto refresh on the server keeps erroring.

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_SpooledOperationMissing","pbi.error":{"code":"DM_GWPipeline_Gateway_SpooledOperationMissing","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Tools Utilized Pivot.
Cluster URI: WABI-US-GOV-VIRGINIA-redirect.analysis.usgovcloudapi.net
Activity ID: 64629198-aca8-4ae6-b51a-b702e065fbcc
Request ID: ac71d365-ca18-bb5e-5b3d-183a05f2cf2a
Time: 2023-08-10 17:05:48Z  

thanks for the help.

[Missy_Perry · Accepted solution]

We had to open a ticket with Microsoft. As it was a bit more complicated.  And the issue is still not resolved. but I am going to take down this thread as it isn't helpful on this board.

[v-binbinyu-msft]

Hi @Missy_Perry ,

Please review the solution in the following links and check whether they could resolve your problem:

Solved: Scheduler Failed Running: DM_GWPipeline_Gateway_Sp... - Microsoft Fabric Community

Power BI On-Premise Data Gateway Error: DM_GWPipeline_Gateway_SpooledOperationMissing","parameters":...

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aj1973]

Hi @Missy_Perry 

You need Power BI Gateway installed on premise 

[Missy_Perry]

Thank you we have one installed. We are taking multiple errors