Sharepoint List On-premise Gateway

[vadlamudibi]

Hello,

I have created report in Power BI Desktop successfully on Sharepoint List as shown below and published to https://app.powerbi.com/ .  

and would to create Sharepoint list as a data source in On-premise gateway for schedules refresh. but unable to create data source for Sharepoint list .

Can On-premise gateway supports Sharepoint List or we have to publishto Power Apps ? can you please provide me the step by step procedure to achieve this?

Thanks in advance.

Best

Venu

[v-frfei-msft]

Hi @vadlamudibi ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank

[v-frfei-msft]

Hi @vadlamudibi ,

Please try to use Odata feed to work on it.

https://social.technet.microsoft.com/wiki/contents/articles/40040.power-bi-two-way-to-get-data-from-...

Regards,

Frank

[TomMartens]

Hey,

I can confimr that an on-premises gateway supports scheduled data refreshes for on-premises sharepoint lists.

Just to be sure, you do not use Sharepoint online?

Unfortunately, from the information you provided, I'm not able to assist you any further.

I guess you are aware of this side:

https://docs.microsoft.com/de-de/power-bi/service-gateway-onprem

There is also a site with known issues and how to overcome them.

Regards,

Tom

[vadlamudibi]

Hello Tom,

Thanks for your response.

In order to schedule refreshes sharepont list in On-premise gateway, when i tried to add sharepint list in on-premise gateway it gives below error message.

Best

Venu