Share point not able to connect

[rajasekaro]

Itry to connect sharepoint not able to connect

how to solve this 

[pankajnamekar25 · Accepted solution]

Hello @rajasekaro 

Correct URL format for SharePoint Folder connection in Power BI:

When using SharePoint Folder in Power BI:

You must use the root site URL only, like

https://yourcompany.sharepoint.com/sites/YourSiteName

Do NOT include

/Shared Documents/...

A specific file name

Any query parameters (?) or fragments (#)

Thanks

 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[Direct · Accepted solution]

Hi @rajasekaro 
You're seeing this error because the SharePoint URL you entered is incorrect.

To fix that, Use the site root URL only.
Example: https://yourdomain.sharepoint.com/sites/sitename
Don't use: file URLs or ones with /Documents or ?query

Steps to connect SharePoint in Power BI:

• Go to Get Data > SharePoint Folder (for files) or SharePoint Online List (for lists)
• Paste the root site URL only
• Click Connect

Make sure you have access to the site. If needed, re-enter your login under Data Source Settings.

Happy to help!
Disha Shree | LinkedIn
If it worked for you, please mark it as Accepted and give it a Kudos 😊

[v-venuppu]

Hi @rajasekaro ,

I hope this information is helpful.If the responses provided by @mark_endicott @Direct @pankajnamekar25  answers your question, please accept their post as a solution,so other community members with similar problems can find a solution faster.

Thank you.

[v-venuppu]

Hi @rajasekaro ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-venuppu]

Hi @rajasekaro ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @mark_endicott @Direct @pankajnamekar25  for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..? If the responses has addressed your query, please accept it as a solution,so other members can easily find it.

Thank you.

[Direct · Accepted solution]

Hi @rajasekaro 
You're seeing this error because the SharePoint URL you entered is incorrect.

To fix that, Use the site root URL only.
Example: https://yourdomain.sharepoint.com/sites/sitename
Don't use: file URLs or ones with /Documents or ?query

Steps to connect SharePoint in Power BI:

• Go to Get Data > SharePoint Folder (for files) or SharePoint Online List (for lists)
• Paste the root site URL only
• Click Connect

Make sure you have access to the site. If needed, re-enter your login under Data Source Settings.

Happy to help!
Disha Shree | LinkedIn
If it worked for you, please mark it as Accepted and give it a Kudos 😊

[pankajnamekar25 · Accepted solution]

Hello @rajasekaro 

Correct URL format for SharePoint Folder connection in Power BI:

When using SharePoint Folder in Power BI:

You must use the root site URL only, like

https://yourcompany.sharepoint.com/sites/YourSiteName

Do NOT include

/Shared Documents/...

A specific file name

Any query parameters (?) or fragments (#)

Thanks

 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[mark_endicott · Accepted solution]

@rajasekaro - Here's the solution:

You should open the Sharepoint Excel file in the desktop app, and navigate to File > Info. Once there you will see a button called "Copy path". 

Click that, and then you'll paste that link into Power BI.

One more step, delete ?web=1 from the end and you should be left with a link that ends .xlsx

If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!