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