Forum Discussion

PowerBISDK's avatar
PowerBISDK
New Member
7 years ago

Custom data connector (SDK) help required

Dear Forum members,   I am working on a small custom connector, it works fine so far. What I wanted to have it before connecting to the service I would have list of names, once user select this lis...
PowerBISDK's avatar
PowerBISDK
New Member
7 years ago

Hi Chris,

 

Thank you very much, appreciated Your response, i did see that but not sure how I am going to work out, infact the link given below from your website has another link within from one of the responses from the  "George Qiaos" to make it dynamic, but his example is within Power BI and uses temporary table within the Power BI. 

 

I am still trying to make sense of your posts which I did try previously but did not get anywhere, any sample with dynamic list would be great if you ahve otherwise I will try and work.

 

I am trying to work out other solution, if you can throw some light or share some sample would be really great. What I am thinking to do is instead for the user which is logged on - I bring the complete dataset with all the dbs the user has access to list them with the number of tables, kind of nested tables but within each databases - ItemKind database.

 

Is there anyway I can itterate through each database name which I bring from the database first and for each database I will then call my service and create a navigational view something like this:

 

DB1
     List of tables (probably 4-5 or may be 10 based on restrictions)

DB2

     List of tables (probably 4-5 or may be 10 based on restrictions)

DB3

      List of tables (probably 4-5 or may be 10 based on restrictions)

 

In simple, I would like to call my service method to provide me list of databases, which then loop through for each of the DB to do a service call with the DB name then bring the relevant tables with the data and create an hierarchical structure based on the database which it belongs to.

  • PowerBISDK's avatar
    PowerBISDK
    New Member
    7 years ago

    Hi Chris,

     

    Thank you very much for your response, Yes, exactly, multi-level or nested navigation, I have tried using the hard-coded sample then changed the code to bring databases dynamically in the name part as below, i have tried to create a sample code for what I required, not sure how to loop through each table to pass its name and get the tables relevant to it:

     

    shared NavigationTable.Nested = (url) as table => let objects

    = #table( {"Name", "Key", "Data", "ItemKind", "ItemName", "IsLeaf"},

    { {GetDatabaseName(url), "n1", NavTable(url), "Database", "Database", false}

      }), NavTable = Table.ToNavigationTable(objects, {"Key"}, "Name", "Data", "ItemKind", "ItemName", "IsLeaf") in NavTable;

     

    GetDatabaseName= (url as text) as table =>
    let

    Source = DataConnector_3.Feed(url & "GetDatabases"), 
    json = Json.Document(Source,1252),
    MyJsonTable= Table.FromRecords(json),
    #"Removed Other Columns" = Table.SelectColumns(MyJsonTable,{"DBName"})

    in
    #"Removed Other Columns";

     

    NavTable = (url as text) as table =>
    let
    source = #table({"Name", "Data", "ItemKind", "ItemName", "IsLeaf"}, {
    { "Table1", GetTable1(url), "Table", "Table", true}
    }),
    navTable = Table.ToNavigationTable(source, {"Name"}, "Name", "Data", "ItemKind", "ItemName", "IsLeaf")

    in
    navTable;

     

    GetTable1 = (url as text,dbname as text) as table =>
    let
    Source = DataConnector.Feed(url & "GetTable1",dbname),
    json = Json.Document(Source,1252),
    MyJsonTable= Table.FromRecords(json)
    in
    MyJsonTable;

     

     

    DataConnector.Feed = (url as text, optional dbname as text) =>
    let
    Credential = Extension.CurrentCredential(),
    split=Text.Split(Credential[Username],"#"),
    source = Web.Contents(url, [ Headers = DefaultRequestHeaders, ManualCredentials = true, Query = [
    user_key = split, db_name=dbname]]),
    json = Json.Document(source)
    in
    json;

     

    I am not sure, how to itterate the "NavigationTable.Nested" function for each database for which the db name would be pass to CreateNavTable funtion.

     

    I have searched internet and still un-able to find any sample which helps me create dynamic navigation.

     

    Do you know any sample available for dynamic navigation? Would be really helpful.

     

    Kind regards,

     

    • Anuj6's avatar
      Anuj6
      Frequent Visitor
      6 years ago

      Hi,

       

      Were you able to find the solution to this problem, i am also trying to do something like this in my custom connector.

       

       

      Thanks