Sharepoint connector cannot see file in personal folder

[Anonymous]

Hello,

I am battling with this problem since yesterday. 

My colleague shared an excel file that will be regurarly updated, but I cannot find a way to connect to it with Power BI.

Usual Sharepoint Folder connector (with API = 15) doesn't show anything in her folder

Sharepoint Folder connector where API = 14 shows excel file that was created one day later but not the one that I want

And OData feed shows both files but I don't have option to open the file with OData. 

For Web I get access denied (with both Windows and Organizational account), 

And in embed I cannot see auth part of the link or the second one. 

Can somebody help me? 

[Anonymous]

I managed to find the file but I am getting 500 error

SPRequestGuid=7fdd449f-6057-b000-12ef-24b3cb3528e2

DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (An error occurred while processing this request.)
Details:
DataSourceKind=SharePoint

[Anonymous · Accepted solution]

I went step back and I was having an error on 124th row, so I kept only first 100 rows (files) and now its miracously working! 

But this is just timed bomb now.