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.

v-cazheng-msft's avatar
v-cazheng-msft
Community Support
5 years ago

Hi, ramkula123 

For refreshing dataset from a cloud Excel, you can refer Refresh a dataset from a cloud Excel workbook. Refreshing reports with two data sources may be a bit special. After publishing the report to Power BI Service, you need configure data source in Manage Gateways for each data source in your report and map data source in Datasets setting pane. 

 

 

Best Regards,

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.