Forum Discussion
Linking to an excel file stored in SharePoint 2010
Microsoft EmployeeVanCat2016 -- I think you're correct in using the %20 for the space in the SharePoint name.
In your example, "Site Pages" is an unusual place to have a sub-site. Normally you end up with things more like "https://xyzcorp.sharepoint.com/sites/sub-site-name" are you sure your SharePoint site is underneath the SitePages directory?
I'm not sure actually.
I'm working with a solution (maybe) that someone else gave me from another source. The proposed solution is to map the SharePoint location via Network within Windows Explorer. Then, rather than linking to the file using the choices provided by PowerBI internally, link to the file by choosing "File" and navigating to the file in SharePoint via my mapped Network location.
It makes sense that this would work, but I'm getting an access denied error which is now an entirely different (internal company) problem. Maybe it is actually the root of my inability to grab the data in the first place. I'm the first to look into BI tools at my company. I'm really hoping I can get it up and running soon.
- AaronBator
How are you trying to map to the location? It can be tricky to get the syntax right, but if you go to the SharePoint library and click the "Open with Explorer" button, it should attempt to open up the location for you. If it works, you can map that location. If it doesn't, sounds like you may have an issue like you expected where you don't have the appropriate access to the files.
