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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
szerendipal
Frequent Visitor

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

I have a sharepoint (2010) site with "reports" folder storing excel files. When I try to connect to the site through the connector Power BI just does not import and list any folder or file. Tried different variations of the URL, same result. If I open the sharepoint folder in explorer, the files are clearly visible there. I try to copy the URL with or without the folder included, still the same.

 

The URL looks like this: http://intranetportal/<site>/<subsite>/<mysite>/reports

 

Tried with the site and subsite url, always the same result, empty list.

 

Where's the mistake?

 

Here is a video about the case:

 

16 REPLIES 16
Johanno
Responsive Resident
Responsive Resident

I don't know what the connector is, but maybe someone else will explain here. 

 

Maybe a workaround: When I get data from Sharepoint I open the Excel file from Sharepoint, goto File -> Info and in the top there is the link to the file, e.g.:

https://company.sharepoint.com/sites/folders/filename.xlsm?web=1

then you delete the last characters "?web=1" so that it ends with .xlsm

With this new link you can Get data in Power BI.

This is the sharepoint folder connector. I need to list and combine all files in the folder, not only a single one.

Hi @szerendipal,

Based on my test, It could work on my side:

1.PNG

My URL is like this: http://microsoft.sharepoint.com/<site>/<sitename>

You could refer to below blog for detailed description:https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

 

Regards,

Daniel He

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

Hi, yes, I already tried to follow this article without success: folders and files simply do not load into PBI. I get an empty list so the connection seem to be fine. It is not asking for credentials however.

Hi @szerendipal,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

 

Regards,

Daniel He

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

Sorry, I was on holiday...will check out and test on Monday.

Hi @szerendipal,

I could not reproduce your problem, is your data very large? You could try to refresh it and refer to below link that may have the same problem with you.

https://community.powerbi.com/t5/Desktop/Power-Query-Showing-Data-Field-not-Displaying-Data/td-p/375...

Hope it could help you.

 

Regards,

Daniel He

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

I checked but this does not solve my problem. In the referred article the data is already showing in Power Query. In my case, I'm not even able to see and select the files from the sharepoint - see my screenshots in my original post. So I can't refresh anything. The issue is not with the file size, I'm not even able to select and load any file.

Any other suggestion...???

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.

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

@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.

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

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

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.

Anonymous
Not applicable

Hi, Were you able to find a workaround for this issue?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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