Forum Discussion
SharePoint online to PowerBI- incorrect permissions?
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.
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.
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.