Skip to main content

Power BI

New

Excel Integration with Enterprise Gateway

Vote (30) 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

c709b6ec 420a-496e-99d4-d03ace177f00 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

23829ea9 271b-49ff-b7e1-df50fed2b62d 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.