How to connect share points with power bi desktop

[Sudip_J]

Hi teams,
I want ot learn that how can we connect the power bi desktop with sharepoints .
Please provide the step by step or video link so that i can connect it easily.

Thanks and Regards 
Sudeep Kumar 

[v-veshwara-msft]

HI @Sudip_J ,

We’re following up once more regarding your query. If it has been resolved, please mark the helpful reply as the Accepted Solution to assist others facing similar challenges.

If you still need assistance, please let us know.
Thank you.

[v-veshwara-msft]

Hi @Sudip_J ,

Following up to see if your query has been resolved. If any of the responses helped, please consider marking the relevant reply as the 'Accepted Solution' to assist others with similar questions.

If you're still facing issues, feel free to reach out.

Thank you.

[v-veshwara-msft]

Hi @Sudip_J ,

Just checking in to see if you query is resolved and if any responses were helpful. If so, kindly consider marking the helpful reply as 'Accepted Solution' to help others with similar queries. 

Otherwise, feel free to reach out for further assistance.

Thank you.

[v-veshwara-msft · Accepted solution]

Hi @Sudip_J ,
Thanks for reaching out to Microsoft Fabric Community,

To connect Power BI Desktop with SharePoint, you can follow these steps:

If you're connecting to a SharePoint Folder (e.g. for Excel/CSV files):

1. Open Power BI Desktop.

2. Go to Home > Get Data > More.

3. Select SharePoint Folder > Click Connect.

4. Enter your SharePoint site URL in this format (not the full path to the file):
   https://yourdomain.sharepoint.com/sites/YourSiteName

5. Sign in with your organizational account when prompted.

6. Power BI will list the files in the SharePoint folder. Choose the required file(s) and transform the data as needed in Power Query.

If you're connecting to a specific SharePoint List:

1. Go to Home > Get Data > More.

2. Choose Online Services > SharePoint Online List > Click Connect.

3. Enter the SharePoint site URL:
   https://yourdomain.sharepoint.com/sites/YourSiteName

4. Authenticate using your organizational credentials.

5. Select the required list(s) from the navigator window and load them into your report.

For further details please refer the following links:
Create a report on a SharePoint List in Power BI Desktop - Power BI | Microsoft Learn

Quick steps for connecting to SharePoint using Pow... - Microsoft Fabric Community

Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.

Thank you

[TomMartens]

Hey @Sudip_J ,

this articles explains how to connect to Lists inside SharePoint: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list

This article explains how to connect to various sources hosted in SharePoint: https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/Quick-steps-for-connecting-to-Shar...

Hopefully, this helps to tackle your challenge.

Regards,

Tom

[samratpbi]

Hi, copy the location of the file from Sharepoint (if you hover over the file, 3 dots appear, from there go to details and copy the path of the file). Then from Power BI, select Web as data source and simply paste the path. You should be able to connect.

If this helps to resolve your problem, then please mark it as solution, thanks!

[amit_maniyar]

Hi @Sudip_J ,

are you looking to get a sharepoint List? or excel file that is sitting on your sharepoint channel?

I can recommend this video by Avi singh to get you started.

https://youtu.be/XuLnSYjmsJo?si=gejueyVsYCPD_m3y