cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aplaza Frequent Visitor
Frequent Visitor

Custom connector Power Bi

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Moderator v-yuezhe-msft
Moderator

Re: Custom connector Power Bi

@aplaza,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Moderator v-yuezhe-msft
Moderator

Re: Custom connector Power Bi

@aplaza,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
aplaza Frequent Visitor
Frequent Visitor

Re: Custom connector Power Bi

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.
 
Highlighted
Moderator v-yuezhe-msft
Moderator

Re: Custom connector Power Bi

@aplaza,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
aplaza Frequent Visitor
Frequent Visitor

Re: Custom connector Power Bi

ok, thank you