Kerri has attended:
Excel Intermediate course
Excel Advanced course
Excel Dashboards for Business Intelligence course
Power BI Reporting course
Power BI Modelling, Visualisation and Publishing course
Obtaining data from sharepoint
All our company data is saved on sharepoint, however, when I add the URL, power BI gives me the following error 'unable to connect' - it doesnt seem to matter how I adjust the URL, I still get the same error, unless I point the URL to our entire company sharepoint (rather than a folder in sharepoint) and then there are 1000's of files that it tries to obtain. Any suggestions on how I grab info from a folder on sharepoint?
RE: Obtaining data from sharepoint
Hi Kerri,
Thank you for the forum question.
You didn't write if you need to connect to a SharePoint list, folder, or a Excel file stored on SharePoint.
I found a video on YouTube, which shows have to connect to list, folder, and Excel file on SharePoint.
See link below to the video:
https://www.youtube.com/watch?v=XuLnSYjmsJo
Let me know if the video doesn't make sense
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
