Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
HassanAli123
Helper I
Helper I

Power BI is not connecting with SharePoint

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,

8 REPLIES 8
khaledHabib90
Resolver II
Resolver II

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

khaledHabib90_0-1697703825029.png

if it is a onedrive folder please follow the below

khaledHabib90_1-1697703887559.png

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

khaledHabib90_2-1697703935569.png

 

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

christinepayton
Super User
Super User

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). 

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?

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:

 

christinepayton_0-1697731393845.png

 

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

Idrissshatila
Super User
Super User

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 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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

HassanAli123_0-1697611351352.png

 



@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 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.