Question

A finance team publishes a semantic model that combines data from an on-premises SQL Server database and a SharePoint Online list. An on-premises data gateway (standard mode) is already installed and running. When the analyst configures scheduled refresh, the SQL Server source shows a valid gateway data source mapping, but the SharePoint Online source displays a warning that no gateway connection is available. The analyst must enable scheduled refresh for the entire model with the least administrative effort. What should the analyst do?

Accepted Answer

Configure the SharePoint Online source to use cloud connection credentials directly, since the gateway is only required for the on-premises SQL Server source.

Answer

Add the SharePoint Online list as a new data source under the existing on-premises data gateway and map it in the model's gateway settings.

Answer

Install a personal mode gateway on the analyst's machine to handle the SharePoint Online refresh.

Answer

Split the model into two separate semantic models so each data source can refresh independently.