Skip to main content

    Power BI

    Needs Votes

    Excel Integration with Enterprise Gateway

    Vote (32) Share
    Mani Peddada's profile image

    Mani Peddada on 03 Aug 2016 03:49:51

    For excel data that is put in PowerBI Desktop as a source, and then published to Power BI, you currently need a personal gateway to refresh that, as Power BI recognizes it as coming from an on-premise source, which requires the use of a gateway to refresh. Can this be enable for enterprise gateway as well please? Since at the enterprise level you are most likely to use enterprise gateways rather than personal gateways

    Comments (2)
    Mani Peddada's profile image Profile Picture

    Bjarki Már Gunnarsson on 05 Jul 2020 23:32:37

    RE: Excel Integration with Enterprise Gateway

    Same issue?
    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15561135-route-analyze-in-excel-odc-through-power-bi-api

    Mani Peddada's profile image Profile Picture

    Jon Fortner on 05 Jul 2020 23:10:12

    RE: Excel Integration with Enterprise Gateway

    This already works, but you specify a Folder connection, not an Excel one. Then any datasets that connect to Excel files in that folder or its subfolders should work using that same connection.