Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    7 years ago

    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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Anonymous
      Not applicable

      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's avatar
        Anonymous
        Not applicable

        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