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.
