Power BI is not connecting with SharePoint

[HassanAli123]

Hi,
I am trying to connect power BI with Service (Common) account with sharePoint but its saying "Could not authenticate with the credentials provided". when i try to open the sharePoint through the service account on Browser its accessible its mean i have the access of sharepoint. but its not connecting with power BI. kindly suggest the solution in detail.

and is it necessory to have pro license to access sharePoint?

Regards,

[khaledHabib90]

Hi Hassan,first you need access to the specific site/folder/file you are trying to connect to if you are trying to connect to a folder on a sharepoint site to combine the files in it please follow the below

if it is a onedrive folder please follow the below

if you are trying to connect to a specific file on onedrive or sharepoint site, please use the below

If I answered you question, please mark my reply as the solution 🙂

[christinepayton]

What are you trying to connect to, a list or a folder of files or? Make sure when it asks for credentials to select the Microsoft account type if it's SharePoint Online (I think iit defaults to anonymous, which won't work). 

[HassanAli123]

I am trying to connect a folder. and using the Microsoft account for authentication but its not working. can it be the error of sharepoint that sharepoint is not allowing me to access from other application?

[christinepayton]

The most common problem people have with this connector is giving it the wrong URL when connecting. It wants a raw site path, not a folder path, then you filter down to the folder. If you want to post the URL you're using with the tenant name removed, that would help troubleshoot. You might also try enabling this setting in the PBI settings:

I've had this fix auth issues with SharePoint previously, but usually it's a different symptom. 

[Idrissshatila]

Hello @HassanAli123 ,

connecting from power bi to sharepoint from the connector doesn't require a license.

can you try this and see if it works https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[HassanAli123]

its not working. and let me know the difference between the following 3 methods.

[Idrissshatila]

@HassanAli123 ,

you can check them here from the microsoft documentations with details

SharePoint List https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list

SharePoint folder https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder

SharePoint Online list

https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-online-list

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[HassanAli123]

Thanks for sharing the links but my problem is still there. not able to connect power BI with SharePoint.