Custom connector Power Bi

[Anonymous]

Hello,

I need create a new cutom connector for Power Bi. In the code is necessary put conection to the database included user and paswword for to connect automatically.

In the next try i put the folow code:

section HelloWorld;

[DataSource.Kind="HelloWorld", Publish="HelloWorld.Publish"]
shared HelloWorld.Contents = (optional message as text) =>
//     let
//         _message = if (message <> null) then message else "(no message)",
//         a = "Hello from HelloWorld: " & _message
//     in
//         a;

        let
            HELLO = Oracle.Database("ORADES11", [HierarchicalNavigation=true, Query="ANY QUERY"])
        in
            HELLO;

// Data Source Kind description
HelloWorld = [
    TestConnection = (dataSourcePath) => {"HelloWorld.Contents"},
    Authentication = [
        UsernamePassword = [Username = "USERNAME", Password = "PASSWORD"]
    ],
    Label = Extension.LoadString("DataSourceLabel")
];

what I try to do is pass the database, a query already made and the credentials so that automatically in power bi desktop, login automatically .

I do not know if it is possible in a connector and if so I do not know how it could be done.

Thank you

[Anonymous]

@Anonymous,

I don't think it is possible to hard-code the usename and password in the code to make login automatically in custom connector.

You can define different authentication types(OAuth, Key, Windows, Basic (Username and Password), and anonymous credentials) following the guide in this article, but you still need to manually enter username and password when using the custom connector in Power BI Desktop.

Regards,
Lydia

[Anonymous]

ok, thank you,

Now, i put:

section HelloWorld;

[DataSource.Kind="HelloWorld", Publish="HelloWorld.Publish"]
shared HelloWorld.Contents = (optional message as text) =>

    let
			qry = "Select.....",
			Source = Oracle.Database("ORADES11", [HierarchicalNavigation=true, Query=qry])
    in
                        Source;

HelloWorld = [
    TestConnection = (dataSourcePath) => {"HelloWorld.Contents"},
    Authentication = [
        Anonymous = []
    ],
    Label = Extension.LoadString("DataSourceLabel")
];

HelloWorld.Publish = [
    Beta = true,
    ButtonText = { Extension.LoadString("FormulaTitle"), Extension.LoadString("FormulaHelp") },
    SourceImage = HelloWorld.Icons,
    SourceTypeImage = HelloWorld.Icons
];

HelloWorld.Icons = [
    Icon16 = { Extension.Contents("HelloWorld16.png"), Extension.Contents("HelloWorld20.png"), Extension.Contents("HelloWorld24.png"), Extension.Contents("HelloWorld32.png") },
    Icon32 = { Extension.Contents("HelloWorld32.png"), Extension.Contents("HelloWorld40.png"), Extension.Contents("HelloWorld48.png"), Extension.Contents("HelloWorld64.png") }
];

when trying to connect the message comes out:  "specify how to conect" when trying to put the credentials for to connect to database.

I cant to connect to database.

If i open a new power bi and i do new login to the same database the login is successfully.

[Anonymous · Accepted solution]

@Anonymous,

Why not use built-in Oracle connector in Power  BI Desktop? As per this article, for custom connector, Currently, a limited set of data source functions have been enabled to support extensibility. It doesn't support using Oracle.Database function.

Web.Contents
OData.Feed
Odbc.DataSource
AdoDotNet.DataSource
OleDb.DataSource

Regards,
Lydia

[Anonymous]

ok, thank you