SharePoint online to PowerBI- incorrect permissions?

[tkboisvert]

I have a few files I'd like to distribute to other members of my team. They live inside documents Apps in the root of our share point. I can see them (When I go Get data > Share point ) and another member can see them, but Everyone else gets stuck 'connecting' to share point. 

I'm fairly certian it's a permissions problem, but I can't seem to get the combination right. Does anyone know exactally which permissions need to flipped on, or if this is a different problem I need to resole?

[norahfox]

Have you figured out what is up with this? I've been completely unable to access SharePoint files with the eternal "Connecting..." message as well.

[tkboisvert]

I think it's more of a licensing issue actually. I've been trying to do some testing, however there is a huge time delay on it.

It seems that users with Office 365 Licenses have access to it after 30 mins - 24 hours.

Users without Office 35 Licenses get the 'Connecting' problem.

It's very difficult to trouble shoot because of the time it takes to go from one scenario to the next.

If you have a user without a license and you assign it one, it could take up to two days to actually get access to SP.

It works the other way as well. So if you remove a license from a user, It still has access to the SP for a while. I'm trying to see if any files you bring through while you have access to the SP are still accessible even after you cant access the SP.

Edit: My suspiscions have been are looking more correct. A Office 365 License includes a licence to SharePoint.

You can however get SP only licences for like CAD $6.10. So that's good.

[tkboisvert · Accepted solution]

Again, looks like I was wrong. A user can have no O365 licences, and just have permissions to a folder or file in sharepoint and still access the SP in PBI.

I have spoken with Power BI, to connect to SharePoint Online from inside PBI, a user must have a licence to use SharePoint.