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...
cwebb's avatar
cwebb
Advocate V
7 years ago

If I understand you properly, then yes I think it should be possible. You should return a function in your Navigation table and then do something like this to populate the dropdown lists:

https://blog.crossjoin.co.uk/2014/11/27/specifying-allowed-values-sample-values-and-descriptions-for-function-parameters-in-power-querypart-1/

https://blog.crossjoin.co.uk/2014/12/02/specifying-allowed-values-sample-values-and-descriptions-for-function-parameters-in-power-querypart-2/

 

Chris

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.