cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pedrortm Frequent Visitor
Frequent Visitor

Re: Unable to import from sharepoint - folder and file list stays empty

Yes @szerendipal, when filtering the URLs in query edit mode, within PowerBI or Excel, select the option "contains" instead of "equals". This way all sub folders will be included.

szerendipal Frequent Visitor
Frequent Visitor

Re: Unable to import from sharepoint - folder and file list stays empty

I'm sorry, but what do you mean "filtering URL"? I'm not filtering anything, the table is empty. If I go to the query editor and click on Source setting there are no options you mention, it is just showing the link of the site which contains the folder and files - and which just don't show up.

 

query_editor.PNG

pedrortm Frequent Visitor
Frequent Visitor

Re: Unable to import from sharepoint - folder and file list stays empty

@szerendipal Ah, I see. In that case I'm not sure what's wrong. Looking at your URL, it doesn't include sharepoint. My sites' URLs look like this:

 

https://tenantname.sharepoint.com/sites/sitename/ for example, where tenantname is the domain name that was registered when setting up office 365 (with the tenantname.onmicrosoft.com ending), not necessarily the one where the email's domain points to.

 

Hope this helps.

szerendipal Frequent Visitor
Frequent Visitor

Re: Unable to import from sharepoint - folder and file list stays empty

We have sharepoint 2010, is this maybe the reason behind...?

pedrortm Frequent Visitor
Frequent Visitor

Re: Unable to import from sharepoint - folder and file list stays empty

No idea, but I would see that as a real possibility.

szerendipal Frequent Visitor
Frequent Visitor

Re: Unable to import from sharepoint - folder and file list stays empty

OK, thanks, I will email the support directly and leave a comment here once this gets confirmed. Until then, I will keep the topic open - maybe somebody else has something to add.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 54 members 1,152 guests
Please welcome our newest community members: