Power BI connector and On-Premises Data Gateway

Kathy Ballew

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!

Dan Snyder

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

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

Thanks for that update.

Jeff Johnson

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.

Refreshes have been successful. Hope this helps.

Jeff