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.
I have a report that has two datasources:
- SAP BW
- Sharepoint online list
If I publish the report and scheduled a refresh, it works great.
But I use a merge or an append between them, the option is not available anymore and instead the following message appears:
You have no gateway installed or configured for the data sources in this dataset. Install a new data gateway or configure the data source for an existing data gateway.
Do you have this problem???
Hi @JuliaYebra,
As error message pointed out, please try to add both data sources to gateway and test again.
Regards,
Yuliana Gu
The sharepoint online list doesn't need a Gateway.
Also, the scheduled refresh works well with the 2 sources at the same report when you have them separated.
The problem appears when you use a merge or an append combination. At that point, the BW gateway can't be selected anymore.
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.