PowerBI linked to SharePoint Lists require a Personal Gateway?

[GrahamKnowles]

I've got a list created in SharePoint online which i want to use to display data into a PowerBI report.

I've connected the list into an excel spreadsheet through the Export to Excel option in the ribbon.  This spreadseet is then also saved into the SharePoint online site.

I've used the PowerBI desktop app to pick up this data from the spreadsheet and create a PowerBI file which is published to PowerBI.

I can now see and interact with the report within PowerBI, however i can't enable a scheduled refresh.  The only option i'm given is to create a Personal Gateway to allow scheduled refresh.  However i was under the impression (from this article https://support.powerbi.com/knowledgebase/articles/649846-power-bi-personal-gateway) that a gateway would not be required as the data is connected to an online source rather than on-prem data

Is anyone able to shed some light on this for me?  

Thanks

[Kandy]

Thanks works for me.

[NShan]

Hi,

I could connected PBI desktop to my SharePoint list, But i could not get the exact column and data in the preview. It shows something like FileSystemObjectType,ContentTypeId,AuthorId. etc other than the columns in the list and the list data in the site.

Any help would be appreciated!

Thanks!

[sdeoghar]

Hi 

did you happend to get this issue resolved. I am facing this error while connecting Sharepoint list directly to power BI.

My web address is of extranet, so is this an issue? can you suggest.

I want to make sharepoint list and power BI connected directly, but unable to do so.

Shivjeet Deoghare

[MattViner]

This worked for me. Thanks

[Ramakrishnan]

I tried linking to a particular table in sharepoint after navigating throug the root site. But after selecting the table, I am getting an error of 'User is not Authorized'. I have read access to the sharepoint list and I have a sharepoint license. What other access do I need?