Status:
Accepted
Apply button is greyed out when adding a data source to the on-premise data gateway
I noticed when I published a report with an on-premise data source (SAP BW) along with cloud data sources (Sharepoint), the Apply button is greyed out in the gateway connection settings: ...
I've got a second workaround...
1. Publish a new pbix file with the same name as the original to the workspace, and ensure that you have imported at least 1 table from each data source, however DO NOT include one from Sharepoint.
2. Map your data sources.
3. Replace again with the old pbix file...
this has worked for us here, where the mapping has stayed.