Refreshing Power BI reports from On Prem Flat Files : Data Management Gateway or Power BI Gateway RRS feed

  • Question

  • Hi 

    We are working on a Power BI solution. We currently have the Power BI reports sourcing data from an Azure data base which in turn sources data from an On Prem database. So we have Data Management Gateway for this purpose.

    Now we are getting requests to get the Power BI reports refresh off excel files stored locally On Prem. 

    Question: Do we need to install Power BI Gateway for this purpose or could we reconfigure the already installed Data Management Gateway to enable the Power BI refresh with the locally stored flat files?



    Saturday, February 4, 2017 8:20 AM


  • Hi Nithin,

    You need the PBI gateway for this purpose. Unfortunately the ADF gateway is exclusive for a single ADF instance and you can't use it for BPI or other services.



    Jorg Klein's Microsoft Business Intelligence Blog

    Monday, February 6, 2017 8:04 AM