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:
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.:
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.
Based on my test, It could work on my side:
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/
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.
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.
Hope it could help you.
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
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.