Power BI connector and On-Premises Data Gateway

Options
Kathy Ballew
Kathy Ballew
Ninth Anniversary Participant Facilitator 1 Loyalty Badge
in SKY Developer General Discussions
Hello,

I am working with the Power BI Custom Connector. I want to set up a scheduled refresh and the documentation I've found for doing that states that I have to set up an On-Premises Data Gateway in Personal Mode. Does anyone know if it really needs to be in Personal mode? It would be better for our process and for continuity if we can use it in enterprise mode which we already have available on campus. Any insights?

Thanks!
Tagged:

Comments

  • Dan Snyder
    Dan Snyder
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper
    Kathy Ballew‍ did anyone respond to you privately? I have the same question about being able to schedule a refresh if we are using the Custom Connector.

    Ben Wong‍ or Dan Bowman‍ maybe you can provide some insight?
  • Kathy Ballew
    Kathy Ballew
    Ninth Anniversary Participant Facilitator 1 Loyalty Badge
    Hi Dan,

    Unfortunately no. I emailed Ben Wong directly and he did not know. He hoped someone in the community would respond. If it were easy to just "try it" I would, but I can't really do that without getting some of our IT folks involved to give me permissions for our enterprise data gateway and help set it up. I'd rather know if it's possible before I start down that path. 
  • Dan Snyder
    Dan Snyder
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper
    Thanks for that update.
  • Jeff Johnson
    Jeff Johnson
    Fifth Anniversary Kudos 1 Participant Facilitator 1

    We were able to successfully add the Power BI custom connector to our enterprise data gateway. Steps are very straight forward using the following instructions:

    The only thing to lookout for is that the service running the data gateway has access to the folder you create for the custom connector. Also, the new data connection type did not show up under Manage Gateways in the Power BI Service until after we restarted the data gateway service.

    f92daafeddf92e0227e6743d2208cc74-huge-im

    Refreshes have been successful. Hope this helps.

    Jeff

Categories