Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
henbri99
New Member

Custom connector data refresh without gateway?

Hi, we are developing a custom connector between a cloudbased service (with SQL Server DBs for the data) and Power BI.

 

The mez-file (connector) works fine in Desktop when refreshing the data. However, we cannot seem to get it to work in powerbi.com when we want to schedule refresh. One guy claims that we need to use a gateway for custom connectors, true? This would be less elegant and more prone to disturbances and maintenance. 

 

Out of the box in Power BI we find connectors between cloud based services that work fine to schedule without gateways (for ex Zendesk). Isn't it possible to develop a similar for our cloud based service, avoiding the need for a gateway wrt data refresh?

 

--

https://docs.microsoft.com/en-us/power-bi/service-gateway-custom-connectors 

 

 When you build reports in Power BI Desktop that use custom data connectors, you can use the on-premises data gateway to refresh those reports from the Power BI service.

6 REPLIES 6
stijnwingens
New Member

I have the same issue and find that the documentation on this is very meager. Did you get in touch with Microsoft or anyone else?

Hi!

 

Sorry for late response. No, we never got that far. We used the ODATA-connector for our needs eventually. Br/Henrik

Anonymous
Not applicable

Hi had an idea for a solution where the .mez files could be stored in one drive. https://ideas.powerbi.com/ideas/idea/?ideaid=400e730a-75b0-ec11-826e-281878de77da

 

Greg_Deckler
Super User
Super User

For a true custom connector you need a gateway. You would need to get your connector accepted as an official third party connector to be included in the product.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler  Does this mean the Gateway/Power BI Service Refresh resources will be utilized for the Custom Connector Refresh? Or does the custom connector need a Gateway only for the initial handshake? We are trying to use live refresh as we get for Online data sources and would not want the data to come from our cloud source to On-Premise and then back again to the Service. Please advise.

@Anonymous - I can't talk specifics on that, I suggest you track down the folks at Microsoft responsible for third-party connectors, there used to be a program for it that you could enroll in.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.