Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Navigator window not displaying function input parameters. Custom Connector for Power BI

Hi,   I am trying to create a custom connector for Power BI. I have followed the documentation on how to set up a Navigation Table. The table will navigate to three different functions. I have ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    So I found a solution from the PowerBI REST API connector project. Basically you need a special implementation of the Table.ToNavigationTable function. It seems that you need to delete the "Preview.DelayColumn = itemNameColumn" from Table.ToNavigationTable .

     

     

    This implementation of the navigation table works:

     

    Table.ForceToNavigationTable = (
        table as table,
        keyColumns as list,
        nameColumn as text,
        dataColumn as text,
        itemKindColumn as text,
        itemNameColumn as text,
        isLeafColumn as text
    ) as table =>
        let
            tableType = Value.Type(table),
            newTableType = Type.AddTableKey(tableType, keyColumns, true) meta 
            [
                NavigationTable.NameColumn = nameColumn, 
                NavigationTable.DataColumn = dataColumn,
                NavigationTable.ItemKindColumn = itemKindColumn, 
                NavigationTable.IsLeafColumn = isLeafColumn
            ],
            navigationTable = Value.ReplaceType(table, newTableType)
        in
            navigationTable;

     

     

    The only problem I have now is that the documentation is not shown in the Navigator window:

     

    In the Power Query Editor it looks like this: