Forum Discussion
direct path to the excel file or get data through SharePoint?
Hello All, I have a question acording Access from Excel on SharePoint ti Power BI? what is the best approuch, through the direct path to the excel file or through SharePoint? honestly I cannot ...
amitchandak
Super User
Super UserPoma , I think you need to use the link as use that a web, same what is explained here (one drive and sharepoint)
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Thanks for your responce, but what is intresting for me is the difference between the 2 ways. Right now I get access from SharePoint but I want to know if getting access from Direct path is any better.
Hi Poma,
In fact, connect to the 'onedrive business' file link is similar to directly get data from a file. It can be point the data connector to access the root file path. If you use a web connector link to the URL, you can find power bi data connect will return the binary of the file.
Regards,
Xiaoxin Sheng