Gateway - SharePoint List & SAP HANA Direct Query

[mshilendhari]

Hi all,

I have a report in which there are two sources,

1. SharePoint List

2. SAP HANA connection in Direct Query mode

Per my understanding, SharePoint list does not require a gateway. However, once I added the HANA source in direct query mode, PBI service is requesting for a gateway. I understand that a gateway is required for the HANA source. However, I am prompted to add the SharePoint list URL as well to the gateway. If the same HANA source is in import mode, I am not prompted to add a gateway.

Could someone shed light on how this works please? Why does SharePoint list require a gateway in case of HANA source being in direct query mode? Is there any workaround to not have the SharePoint list added to the gateway.

Thanks in advance.

[mshilendhari · Accepted solution]

The issue was due to SharePoint site being on premise. We migrated the sharepoint lists to sharepoint online and the issue is fixed. Now only the HANA source requires a gateway.

[TeigeGao]

Hi @mshilendhari ,

According to your description, it looks like that you are using an online Sharepoint list, you can try to use the connector Sharepoint Online List rather than Sharepoint List. Actually, it doesn't require a gateway when connect to an online resource.

Best Regards,

Teige