Forum Discussion

kjohn10's avatar
kjohn10
Icon for Helper I rankHelper I
9 years ago
Solved

Unable to set enterprise gateway for data source after publishing

I have a pbix developed in desktop, with a few data sources using ODATA connection to SAP.

Everything works fine on desktop. I then publish it to our powerbi.com, and it shows up in the Reports and it opens fine.

Now I want to schedule it for auto-refresh, however I run into this error message:

 

You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway.

(see image below).

 

On that screen, I am not able to select 'Use a data gateway'. We have our enterprise gateway already installed and working for other reports. These few data sources have been configured on that gateway already. Why can I not select a gateway?

 

Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi kjohn10


    That would often happen when one of the sources is not configured in the On-Premise Gateway.

     

    What I would suggest doing is to open your Power BI Desktop file and click on Data Source Settings. See how many data sources you have in there, and then see how many you have and how they are configured.


    Then ensure that you have the identical setup in the Power BI On-Premise data sources in the service.

5 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    9 years ago

    Hi kjohn10


    That would often happen when one of the sources is not configured in the On-Premise Gateway.

     

    What I would suggest doing is to open your Power BI Desktop file and click on Data Source Settings. See how many data sources you have in there, and then see how many you have and how they are configured.


    Then ensure that you have the identical setup in the Power BI On-Premise data sources in the service.

    • kjohn10's avatar
      kjohn10
      Icon for Helper I rankHelper I
      9 years ago

      Thanks. Looks like it came down to the "Authentication Method" configuration; In desktop, all 3 feeds were set to 'Anonymous', but in powerbi.com 2 of the 3 were set to 'Windows' auth. Changing those 2 to 'Anonymous', and now I was able to select the gateway for scheduled refresh.

       

      Just tried a scheduled refresh, and it failed. All I got was "Oops, something went wrong." email notification. The [Learn More] link leads to a page full of random stuff to check and try, yikes. Off to troubleshoot more. I wish the email had a little more detail as to what "went wrong".

       

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi kjohn10,

    Please click "Manage Gateways" under setting in Power BI service, open the ellipsis(...) on the right of your gateway. And check if you add the Odata data source. If you haven't, please add the dataresource first as the screenshot below.



    Except that, I glad to help you if you have any other peoblems, please feel free to ask.

    Best Regards,
    Angelia