Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
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
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.