Share Point/Office 365 connectivity issues

vtcusascott,

If you store Excel file under SharePoint Online Documents, you can paste the URL in Web entry of Power BI Desktop and use “Organizational account” to connect to it.

https://microsoft.sharepoint.com/XXX/XXXX/Shared%20Documents/ExcelName.xlsx

If you store Excel file in SharePoint Online folder, enter the root URL of SharePoint online site in “Get Data->SharePoint folder” , then use “Microsoft account” to connect to it, you will be able to extract data from your Excel file.

If you still fail to connect to the Excel file, please post the error message here.

Regards,
Lydia

Thank you very much for your response. I'd forwarded it on to our Share Point consultant and it was helpful to him in making the following suggestion- which worked perfectly! Keep in mind that the structure of our document library was different than it might appear if you just create a page or team site. In any case I hope this might be useful to someone else having the same problem as it was a roadblock for me until I was given this suggestion. The hyperlink mentioned worked well when used in tandem with the "Web" data sorce in Power BI. Here is the relevant part of his response......

"So for the views used throughout your company, the file menu using the “3 dots” to the right of the file name provides the most file options which is why  it was chosen… except the one option to get the cleanest URL  ;)

To get the cleanest URL for a file:

1. Click the checkbox to the left of the file name.  This will expose a “Files” and “Library” menu options in the top, light blue bar of SharePoint.
2. Click on “Files” in the light blue bar of SharePoint.
3. Click on “View Properties”
4. This will produce a light “Properties” view, but the most important is the hyperlink to the file.  Right click on the hyperlink to the file and choose “copy link address” (text for copying link may vary depending on which browser you are using… I am using Chrome)

Thanks again for your help I appreciate it!