Obtaining data from sharepoint

Resolved · High Priority · Version 365

Thu 3 Feb 2022, 09:33 Delegate Kerri said...

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?

Thu 3 Feb 2022, 10:04 Trainer Jens said...

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

Training courses

	98.7 % recommend us
	More live stats...

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Power BI tip:

Master the Power BI Custom Visuals

Power BI offers a variety of custom visuals created by the community and Microsoft. Explore these visuals to enhance your reports and dashboards. Whether it's a custom map, a timeline, or a unique chart type, custom visuals can add significant value to your visualizations.

View all Power BI hints and tips