HDTutorial
EN
How to use Power Query to connect to a file on OneDrive or SharePoint

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to use Power Query to connect to a file on OneDrive or SharePoint

72,804 views March 25, 2020 20:01

Watch on YouTube
ChannelAccess Analytic

Chapters

Description from the creator

***READ THIS UPDATE from MAY 2021**** 💎
I've a quicker technique for the From Web Method now
Check it out...youtu.be/vPV67RLGoOg
*********************************************


0:00 Intro
1:15 Using the From Web method
5:29 Using the From SharePoint Folder method
14:05 Using the SharePoint.Contents trick

Connecting to a file stored on OneDrive or SharePoint using Power Query is not as straight forward as Get Data from Excel Workbook, or Text / CSV

There are a couple of options:
From Web
From SharePoint Folder

Please vote here to make this whole process easier....
Excel:
excel.uservoice.com/forums/274580-excel-for-the…

Power BI:
ideas.powerbi.com/forums/265200-power-bi-ideas/…

About this tutorial

Access Analytic published this 20:01 video tutorial on March 25, 2020. It has been watched 72,804 times on YouTube.

Duration
20:01
Published
March 25, 2020
Views
72,804
Likes
827

Tags

Share

This tutorial in other languages