Forum Discussion

ramkula123's avatar
ramkula123
Helper I
5 years ago
Solved

refreshing reports with 2 different data sources

We have a single report with 2 sources (import query mode) 1. SAP HANA &  2.Excel from sharepoint The data gets refreshed when excel is updated successfully in desktop. However once published to PB...
Need Help
  • SpiroswayGR's avatar
    SpiroswayGR
    5 years ago

    ramkula123 

    I think you should use on premises gateway , then you can connect pbix in powerbi service with data sources.

ramkula123's avatar
ramkula123
Helper I
5 years ago

The report connects to the SAP HANA source via enterprise gateway. Is it possible to have both on prem and enterprise gateway to connect to 2 different sources in a single report ?

  • SpiroswayGR's avatar
    SpiroswayGR
    Resolver III
    5 years ago

    ramkula123 

    I am not sure about that, because if you check on powerbi service is connected with one gateway and then select databases / tables.

    Is any way to use enterprise gateway for excel file too ?