cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
szerendipal Frequent Visitor
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:

 

15 REPLIES 15
Johanno Member
Member

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

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.

szerendipal Frequent Visitor
Frequent Visitor

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

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

v-danhe-msft Super Contributor
Super Contributor

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

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.
szerendipal Frequent Visitor
Frequent Visitor

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

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.

v-danhe-msft Super Contributor
Super Contributor

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

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.
v-danhe-msft Super Contributor
Super Contributor

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

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.
Highlighted
szerendipal Frequent Visitor
Frequent Visitor

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

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

szerendipal Frequent Visitor
Frequent Visitor

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

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.

szerendipal Frequent Visitor
Frequent Visitor

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

Any other suggestion...???

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 163 members 1,984 guests
Please welcome our newest community members: