How to list down dynamic values via Documentation.AllowedValues in Power Query

[Mohanasudharsan]

Hi Power BI Community,

We are developing a custom connector in which we need to fetch a list of available tables via the web.contents are then displayed in Power BI UI for the end user to select any one.

But Documentation.AllowedValues is accepting only static values like {"Table1", Table2", "charts"}. Whereas we want to fetch these data from REST API dynamically and then display them. I am adding the code reference for the custom connector.

shared Connector.ContentsType = 
let
    response = getAllData(),
    tables = response[data],
    allowedValues = Table.Column(dataSources, "tableName"),

     type_name = type text meta [
			Documentation.FieldCaption = "Enter the table name",
            Documentation.AllowedValues = allowedValues
		],  
		CType = type function (dataSourceName as type_name) as table
in
    CType meta [
          Documentation.Description = "Enter Connector Information",   
          Documentation.DisplayName = ModuleName,
          Documentation.Name = ModuleName,
          Documentation.Caption = ModuleName
   ];

 
Any idea to tackle this would be helpful.

[lbendlin]

Web.Contents connectors are Import Mode only.  Can't do anything dynamically with them.

[Mohanasudharsan]

I agree. But I want to call it a web.contents REST API as soon as the connector is chosen and the user interface appears for "Table Name" entry.

Currently I am to call web.contents after username and password are entered. But my requirement is to call an api even before credential request UI.

[lbendlin]

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41