Forum Discussion
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
- lbendlinSuper User
Web.Contents connectors are Import Mode only. Can't do anything dynamically with them.
- AnonymousNot 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.- lbendlinSuper User
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