I'm having a huge amount of difficulty with two issues related to my company's housing of all its work related Excel files in an Office 365/SharePoint environment. Though the desktop tool works great on local files and in tandem with SQL generated versions of my ERP, I'm stuck when trying to connect to Excel files that live in our SharePoint system. I've tried "getting data" from a "Web" source, a "SharePoint Folder" and a "SharePoint List" with little luck. When I am able to bring information in it looks to be page data, is unusable, or does not correlate with what I would expect to see with the supplied URL. If I try to supply a more detailed URL it fails. As a connected issue can map a network location to the SharePoint location on my local drive and tell PBI to get an excel file using that path, but ultimately that path breaks when I restart my machine so It takes automated refreshing off the table. Incidentally connecting to these files with the online PBI service is easy but I can't build and do the same data manipulation on the web so that shuts me down there. Any help anyone can provide would help. Additionally, if anyone could recommend a good consultant that has deep expertise on SharePoint/PBI I'm really thinking that they could solve this issue pretty quickly for us, so suggestions would be welcome.

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

Share Point/Office 365 connectivity issues | Microsoft Fabric Community

Forum Discussion

Related content

Data Gateway Connection Issue

Fabric Lakehouse connection issue

Lakehouse connection issue

Connection Timeout Issue

Connectivity Issue : Power BI to dynamics 365 (Dataverse)