Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

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.

3 Replies

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      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.