Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
XIOFEN_LIM
Helper II
Helper II

Scheduler Failed Running: DM_GWPipeline_Gateway_SpooledOperationMissing

Hi,

 

I may need help about issue below. 

Scheduler failed running by shwing this Gateway_SpooledOperationMissing error. 

This issue happen since yesterday afternoon. This morning I have tried to restart the gateway and schedule auto refresh at 930am and it running successfully. When come to next auto refresh, the same error shown.

 

{"error":{"code":"DM_GWPipeline_Gateway_SpooledOperationMissing","pbi.error":{"code":"DM_GWPipeline_Gateway_SpooledOperationMissing","parameters":{},"details":[],"exceptionCulprit":1}}} Table: V_QA.

2020-04-17 11_34_08-Window.png

1 ACCEPTED SOLUTION
XIOFEN_LIM
Helper II
Helper II

Hi,

 

I have fixed the issue by changing the source database name to IP in Power BI files, republish them and reset the gateway connection.

It happened because yesterday my colleague hav setup Azure could server with VPN and cloning from on premises server.

both DB showing same name causing gateway failed to reconigze which DB to refer.

View solution in original post

5 REPLIES 5
XIOFEN_LIM
Helper II
Helper II

Hi,

 

I have fixed the issue by changing the source database name to IP in Power BI files, republish them and reset the gateway connection.

It happened because yesterday my colleague hav setup Azure could server with VPN and cloning from on premises server.

both DB showing same name causing gateway failed to reconigze which DB to refer.

@XIOFEN_LIM   Hello, how do you change source database names to IP In power bi files?

Hi @jcastr02 ,

 

Open the pbx file --> click "File" tab -->select "Options & settings" -->click "Data Source Settings" --> select the source then click "change source" button --> change the info then save

Anonymous
Not applicable

'Changing the source database name to IP'

What is meant by IP in here?

Hi @XIOFEN_LIM ,

 

It's glad that you have solved your problem.
Please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors