Forum Discussion
Add Sharepoint List Data Source to Gateway
Has this issue been resolved? I am experiencing the exact same problem.
I was able to add a "Sharepoint List" as a datasource on the Power Bi desktop application but there is no option for a "Sharepoint List" when setting up the gateway datasource settings. I only see a "Sharepoint" datasource and when trying to add this I receive the same error Anonymous received.
Update:
The issue it appears that I've ran into is actually that the service seems to limit the number of servers a report can use a single gateway for if you're not an admin over the gateway.
Regular users can only select the gateway if they have one sql server in the data sources.
It sounds like this is not intended behavior and may be fixed in an update but I have no ETA based on talking with support.