Using a Custom Connector for Automatic Data Refreshes on One-Drive

[TLibson]

I'm currently using a custom connector to get data from an Odoo Online database for my company's reporting needs. Right now, to refresh the data, I need to run the data refresh on my personal computer. Eventually I want the Semantic Model's data to automatically refresh on One Drive, but I'm worried that I won't be able to do that since I'm using a custom connector. This is the github for the connector I'm using: https://github.com/tmijail/Odoo-Power-BI-Connector/blob/master/Odoo.pq . Is there a way to add this connector into a workspace?

Thanks!

[lbendlin · Accepted solution]

no, but you can add the custom connector to an On Premise Enterprise Gateway, and then (grudgingly) refresh from your online data source through that gateway.  Not ideal from a performance perspective, but the only way to use the custom connector.

[TLibson]

Thanks for the response! That's what I suspected would need to be done. Fortunately, the dataset isn't crazy big so performance shouldn't be too much of an issue. 

[v-achippa]

Hi @TLibson,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin for the prompt response.

Thanks for the response, looks like the issue is resolved. As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @TLibson,

We haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa