How to connect my Sharepoint folder "My Files" folder through PBI Desktop using SharePoint Folder?

[saliknaveed]

How to connect my Sharepoint folder "My Files" folder through PBI Desktop using SharePoint Folder?

full link of the folder example:

https://[company_name]-my.sharepoint.com/my?id=%2Fpersonal%[user_name]%domain%5Fcom%2FDocuments%2FDocuments%2FSamples%20Data

I've tried with option "SharePoint Folder" in Power BI with follwing links:

1. https://[company name].sharepoint.com/personal/[user name]/ - I get empty table

2. https://[company name].sharepoint.com/ - I get access to some graphic files of a few u

[Nasif_Azam · Accepted solution]

Hey @saliknaveed ,

When connecting to your My Files folder on SharePoint through Power BI Desktop using the SharePoint Folder connector, the method is slightly different from connecting to a typical SharePoint site. Those steps are must be helpful for you:

Step-1: Copy the Correct Base URL
Even though your full folder URL might look like this:

https://[company_name]-my.sharepoint.com/personal/[user_name]_domain_com/Documents/Samples%20Data

You should not paste this entire URL into Power BI.

Instead, use only the root of the SharePoint site:

https://[company_name]-my.sharepoint.com
Avoid using /personal/... or /my links -- they often return empty or unrelated results.

Step-2: Connect Using Power BI Desktop

• Open Power BI Desktop.
• Go to Home → Get Data → More.
• Search and select SharePoint Folder.
• Paste the base SharePoint URL: https://[company_name]-my.sharepoint.com
• Click Connect.

Step-3: Authenticate Correctly: Authenticate as you are suitable for.

Step 4: Filter to Your Specific Folder

• In the preview, click Transform Data.
• In Power Query, use filters on the Folder Path column to narrow down results to: /personal/[user_name]_domain_com/Documents/Samples Data
• You can also filter by file name or extension if needed.

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam

[saliknaveed]

Thank you guys, issue has been resolved

[v-karpurapud]

Hi @saliknaveed 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-karpurapud]

Hi @saliknaveed 

We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you!

[v-karpurapud]

Hi @saliknaveed 

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-karpurapud · Accepted solution]

Hi @saliknaveed 

Welcome to the Microsoft Fabric Forum. Also, thank you @Nasif_Azam and @pankajnamekar25 for your qucik responses.

 The issue you are facing is due to an incorrect URL format when attempting to connect Power BI Desktop to your OneDrive for Business "My Files" folder using the "SharePoint Folder" connector. The URLs you provided do not correctly point to your personal OneDrive storage, resulting in an empty table or unrelated files.
 

The "SharePoint Folder" connector in Power BI Desktop is designed to connect to SharePoint sites and can also work with OneDrive for Business (since it’s built on SharePoint). However, it requires the correct URL to access the folder structure.

For OneDrive, the URL must point to the user’s personal site ([company_name]-my.sharepoint.com/personal/[user_name]_domain_com), and Power BI needs to interpret the /Documents folder as the root.

Attempt 1 failed because it used the wrong domain and an incorrect path structure, resulting in no data being returned.Attempt 2 pointed to the main SharePoint site, retrieving unrelated company files instead of the user's OneDrive content.

 Use the correct URL: https://[company_name]-my.sharepoint.com/personal/[user_name]_domain_com (e.g., https://mycompany-my.sharepoint.com/personal/john_doe_company_com). In Power BI Desktop, navigate to Get Data > SharePoint Folder, input the URL, and sign in with your Microsoft 365 credentials. Filter the Folder Path column to /personal/[user_name]_domain_com/Documents/Samples Data, then click Load.
 

If you face permission issues, confirm access with your IT admin. For single files, you can alternatively use the Web connector with a direct shareable link.

If this response resolves your query, kindly mark it as Accepted Solution to help other community members. A Kudos is also appreciated if you found the response helpful.

Thank you for being part of Fabric Community Forum.

Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.
 

[pankajnamekar25]

Hello @saliknaveed 

Use Web Connector for specific files

Go to your SharePoint "My Files" folder in a browser.

Click on a file (e.g., Excel or CSV) and open it in browser.

Copy the file’s URL (it will be something like https://[company]-my.sharepoint.com/.../filename.xlsx).

Thanks,
 Pankaj Namekar | LinkedIn

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

[Nasif_Azam · Accepted solution]

Hey @saliknaveed ,

When connecting to your My Files folder on SharePoint through Power BI Desktop using the SharePoint Folder connector, the method is slightly different from connecting to a typical SharePoint site. Those steps are must be helpful for you:

Step-1: Copy the Correct Base URL
Even though your full folder URL might look like this:

https://[company_name]-my.sharepoint.com/personal/[user_name]_domain_com/Documents/Samples%20Data

You should not paste this entire URL into Power BI.

Instead, use only the root of the SharePoint site:

https://[company_name]-my.sharepoint.com
Avoid using /personal/... or /my links -- they often return empty or unrelated results.

Step-2: Connect Using Power BI Desktop

• Open Power BI Desktop.
• Go to Home → Get Data → More.
• Search and select SharePoint Folder.
• Paste the base SharePoint URL: https://[company_name]-my.sharepoint.com
• Click Connect.

Step-3: Authenticate Correctly: Authenticate as you are suitable for.

Step 4: Filter to Your Specific Folder

• In the preview, click Transform Data.
• In Power Query, use filters on the Folder Path column to narrow down results to: /personal/[user_name]_domain_com/Documents/Samples Data
• You can also filter by file name or extension if needed.

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam