Power BI Custom Dataconnector Authentication

Question

I am looking create a Power BI Custom Dataconnector that will allow authentication by capturing username, password and then calling webapi to authenticate the user. I have tried the example from

https://github.com/Microsoft/DataConnectors/tree/master/samples/HelloWorld

Which a very basic hello world example without UI to capture credentials. I like to know how to popup a "view" to capture the login details.

score 0 · Accepted Answer · answered Mar 28 '18 at 07:45

The MyGraph sample shows how to perform authentication using OAuth, which is next to basic authentication the only default methods supported.

Basically it comes down in providing an OAuth section in the data source definition:

MyGraph = [
    Authentication = [
        OAuth = [
            StartLogin=StartLogin,
            FinishLogin=FinishLogin,
            Refresh=Refresh,
            Logout=Logout
        ]
    ],
    Label = "My Graph Connector"
];

Note you need methods to perform the actual authentication and token exchange, as described in that sample.

Note that according to the OAuth spec, you should not let the client secret reside on the client, which is often done in these samples. You open up for serious vulnerabilities if you do so, so please be advised.

Thanks, exactly what I am looking for. – mehwish Mar 28 '18 at 08:03 — mehwish, Mar 28 '18 at 08:03

Power BI Custom Dataconnector Authentication

1 Answers1