Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Provide a proper API to both the PowerPivot model and Power Query Workbook Queries

    Vote (7) Share
    TEEGEE's profile image

    TEEGEE on 29 Aug 2015 00:23:41



    Provide a proper API to both the PowerPivot model and Power Query Workbook Queries

    There are scenarios where it would be beneficial to provide a unique UI to users for accessing specific external data, but as it is today there is no proper, fully featured, and understandable API to either the PowerPivot model, or the Power Query Workbook Queries.

    Comments (1)
    TEEGEE's profile image Profile Picture

    TEEGEE on 05 Jul 2020 22:03:54

    RE: Provide a proper API to both the PowerPivot model and Power Query Workbook Queries

    Currently, you can can kind of do extremely simple interactions like so:

    http://www.powerpivotpro.com/2014/07/adding-tables-to-a-model-from-vba-in-excel-2013/

    But it is very obscure and lacks full control.