The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
23 | |
23 | |
18 | |
16 |