Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 PBI cloud any changes made to excel data doesnt get updated in the report.
What is the way to refresh both the HANA and the excel data on cloud report ?
Solved! Go to Solution.
I think you should use on premises gateway , then you can connect pbix in powerbi service with data sources.
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.
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 ?
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 ?
I think you should use on premises gateway , then you can connect pbix in powerbi service with data sources.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
49 | |
28 | |
21 | |
20 | |
20 |
User | Count |
---|---|
52 | |
51 | |
26 | |
26 | |
22 |