on premises data gateway doesn't work

[elads]

Hi,

I get the following message and do not understand why?
Can anyone help? 

[NimaiAhluwalia]

Hello @elads 

Hope your issue is resolved?

[elads · Accepted solution]

Hi @NimaiAhluwalia 

The problem has been resolved!

Here's what I did:

1. Removing and Reinstalling the latest version of the Power Bi Desktop
2.  Replacing the user who runs the on-premises gateway service to Local system
3.  republished the report to the cloud.

[NimaiAhluwalia]

Hello @elads 

That's great to hear.

Accept the relevant answer as the solution to help others.

Regards,

[_sfrost]

@elads 

Did you recently try to perform your server machine (the machine where gateway is installed) cloning? 

If so, check if the cloned machine has gateway installed too. 

Uninstall the gateway from the cloned machine and try to refresh the dataset again.

Did I answer your questions? Give a thumbs up and accept this post as solution!

[elads]

@_sfrost 

The machine has not been duplicated.
Can anyone remote to the server and check?

[NimaiAhluwalia]

Hello @elads 

Hope you are doing good

As the message describes that the issue is with the table PB_shiftandaccidents or any operation that you have performed in the Power Query is missing or not supported try configuring the gateway again and check the source for that table or the operation performed.

If this doesn't help you do open a free support ticket if you are PRO user and they will help you to understand the issue on the backend!

IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!

[elads]

Hi @NimaiAhluwalia 

I am a Pro user How can I open a ticket to support?

Because I clicked on the "Support ticket" earlier and I got here.

[NimaiAhluwalia]

Hello @elads 

perfect click on it you will be guided to the power platform and keep the error screenshot handly as you will require it to upload and they will contact you via phone and email

have a look at this

https://powerbi.microsoft.com/en-us/blog/how-to-create-a-service-request-to-contact-power-bi-support...

Also after clicking above this page will be opened

Then type something on the search and click on the highlighted below.

Fill the details below and raise a ticket

IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!