Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Web.Contents connectors are Import Mode only. Can't do anything dynamically with them.
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.
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