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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
sreeragtg
Frequent Visitor

Connect to OneDrive folder instead of specific files

Hi, 

 

I am trying to connect to my OneDrive folder (https://company-my.sharepoint.com/personal/name_company_com) with no luck.  

 

Get Data -> SharePoint Folder

 

I sign in with the Microsoft Account, but end up getting the below error message.

 

But if I try Get Data -. SharePoint list , I am able to connect but it returns data that doesn't make sense to me.

 

Appreciate any help.

Thank You, 

Sree

 

 

Untitled.png

6 REPLIES 6
v-yulgu-msft
Employee
Employee

Hi @sreeragtg,

 

You want to connect to SharePoint Folder rather than OneDrive Folder, right? If so, please choose SharePoint Folder data connector and enter the SharePoint site URL instead of the complete folder path, similar to:

https://microsoft.sharepoint.com/sitename/subsitename

 

Besides, from this link:

Now that we’re in, we’ll be able to see all of the files from all of the folders that we have access to in that specific site. This might be a pretty long list, so let’s do some filtering on the “Folder Path” column and select the folder where your data is being stored so you only get the files from it.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Yuliana, 

 

Thank You for the reply.

 

When you say SharePoint site URL, is it not the same as what I have in my initial post? 

 

I tried the method based on the link provided. One difference what I find there is: I am not seeing Organizational account to log in, only Anonymous, Windows and Microsoft. Also, I am getting a different error when I use this method. So I didn't reach the stage where I could select the folder.

 

Kindly assist.

 

Untitled - 1.jpg

Hi @sreeragtg,

 

Can you sign in to SharePoint site successfully with current account?

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yulgu-msft, Yes, I can

Hi @sreeragtg,

 

Is your Onedrive for Personal or for Business?

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Onedrive for Business - part of O365 package at work. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.