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

[szerendipal]

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: