Forum Discussion

elads's avatar
elads
Helper III
5 years ago
Solved

on premises data gateway doesn't work

Hi,

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

 

  • elads's avatar
    elads
    5 years ago

    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.

     

8 Replies

  • NimaiAhluwalia's avatar
    NimaiAhluwalia
    Continued Contributor

    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's avatar
      elads
      Helper III

      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.

  • _sfrost's avatar
    _sfrost
    Solution Specialist

    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's avatar
      elads
      Helper III

      _sfrost 

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

    • elads's avatar
      elads
      Helper III

      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's avatar
        NimaiAhluwalia
        Continued Contributor

        Hello elads 

         

        That's great to hear.

         

        Accept the relevant answer as the solution to help others.

         

        Regards,