Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sharepoint connector cannot see file in personal folder

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? 

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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. 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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.