Forum Discussion
Configuring custom connector in Power BI service
Hi All,
I have a custom connector file(.pqx file). I successfully added it to my power bi desktop file and published to service. The problem is adding it as a data source for refresh in gateway. I followed this blog:
https://community.powerbi.com/t5/Community-Blog/Custom-Data-Connector-How-to-Deploy-and-Test/ba-p/862678
I installed gateway and added the connector in the required folder. It is even appearing in the Custom Data Connectors section.
But when I am navigating to gateway in service and trying to add it as a data source it is not appearing in the below dropdown:
Could you help what step i can do to brining the connector in this dropdown?
lbendlinCustom connectors have .pqx extension also. I got it working now. Here is what changes I did:
1) First of all uninstalled "Personal mode" gateway and installed "Standard mode" gateway
2) Went to services -> On-premise data gateway service->Properties ->Log on-> Select Local System Account and check box "Allow Service to interact with desktop"
3) Went to Gateway -> Connectors tab -> Pasted the location where custom connector file is residing
4) Restarted the gateway
Now it is appearing in data source list dropdown in gateway setting.
4 Replies
lbendlinCustom connectors have .pqx extension also. I got it working now. Here is what changes I did:
1) First of all uninstalled "Personal mode" gateway and installed "Standard mode" gateway
2) Went to services -> On-premise data gateway service->Properties ->Log on-> Select Local System Account and check box "Allow Service to interact with desktop"
3) Went to Gateway -> Connectors tab -> Pasted the location where custom connector file is residing
4) Restarted the gateway
Now it is appearing in data source list dropdown in gateway setting.
- lbendlin
Super User
That is great to hear. I don't have experience with personal gateways (haven't run Python/R scripts in anger yet), and on the enterprise gateway the process is relatively stable. One thing I experienced is that one bad connector can bring down all others. For example when you have a code error in one custom connector, all other custom connectors and the hidden SIMBA connectors are blocked as well.
- lbendlin
Did you add it for all gateway cluster members? Is the gateway service user account the same as the user who owns that folder?
- lbendlin
Also, custom connectors normally have a .mez extension, not .pqx
