We have many Excel files on SharePoint Online Document Libraries - well structured and maintained and refreshed. It would be great to be able to point to those directly. The OneDrive for Business i...
When I try to access SharePoint from Power BI desktop and follow: Get data SharePoint Folder The following error is displayed: Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed: OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found) OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found) OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)" If I try to go through web I get the following error: Details: "The input URL is invalid. Please provide a URL to the file path on SharePoint up to the file name only (with no query or fragment part)." There's not a single way for me to connect neither PowerBI Desktop nor PowerBI.com to my SharePoint instance. I do have access to the folder and anything in SharePoint as I'm one of the Global Admins... What should be quite easy is getting more and more difficult. Any step by step to a 5 year old child in how to do it?
