Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.