topic Re: Custom Data Connector to API using OAuth Authentication in Developer

Custom Data Connector to API using OAuth Authentication

Anonymous — Tue, 20 Sep 2022 14:13:06 GMT

Help, please

I have attempted to build a custom connector to handle a connection to a 3rd party API that uses OAuth athentication.

I used Visual Studio 2019 with the Power Query extension and compiled it into a .mez file

I saved the .mez file into documents\Microsoft Power BI Desktop\Custom Connectors folder, howver, it does not appear in the Get Data list. Other custom connectors in the folder are visible in the Get Data\All items list

Perhaps the connectors is wrong somehow?

Re: Custom Data Connector to API using OAuth Authentication

v-chenwuz-msft — Wed, 21 Sep 2022 07:09:06 GMT

Hi @Anonymous ,

In Power BI, the loading of custom connectors is limited by your choice of security setting. As a general rule, when the security for loading custom connectors is set to 'Recommended', the custom connectors won't load at all, and you have to lower it to make them load.

Custom Data Connector: How to Deploy and Test - Microsoft Power BI Community

Handling Connector Signing - Power Query | Microsoft Learn

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Custom Data Connector to API using OAuth Authentication

Anonymous — Wed, 21 Sep 2022 07:51:46 GMT

Thank you for responding.

I should have been clearer in my original post, but I have already made that change to the security settings in Power BI Desktop. As I mentioned I can see 3 of 5 custom connectors, but 2 do not appear in the list at all.

Any idea why?