98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Obtaining data from sharepoint
Obtaining data from sharepoint
Resolved · High Priority · Version 365
Thu 3 Feb 2022, 09:33Delegate 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:04Trainer 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
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Master the Power BI Custom VisualsPower 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. |
