Moving your Excel files to SharePoint or OneDrive? How to update your Power Query connection.

If you already use Power Query to connect to Excel files on SharePoint or OneDrive then this technique is a quick way to replace the required parts of your Power Query Source step so that your refreshes continue to work

Follow me on LinkedIn

Twitter

Access Analytic Training

[sebthedog]

This video has saved me from complete meltdown. Honestly the best video on the internet. Thank you so so much.

[mikedonaldson]

Out of all the searches, all the videos, and all the failed attempts, this (3) minute video just gave me exactly what I needed!

[eimearnicriothaile]

Fantastic simple easy to explain solution, I was wasting an hour reading a wealth of blogs so thank you very much for this!!

[nunomcfa]

Very useful and well explained. Thanks!

[malleshrr]

Thanks for this Video. It saved me lots of time and efforts....

[zyhon]

Thank you so much for sharing. That is the much easier way to do it.

[maryamghaemi]

Thank. Finally I found a helpful video 🙌

[irlandiasantos]

Obrigada!! Me salvou no meu trabalho aqui no Brasil 🇧🇷 God bless you

[jorstube]

Thanks for sharing, useful and simple...

[FoxzLady]

Hi! In the event it is a report you update monthly, the new month eg csv file, do you save it to the original folder or the One Drive/Sharepoint folder? Am I mailing sense? Thanks for these amazing tutorials!

[OrlandoCeleiro]

Great info !!! What if instead of having a single Excel file the source we have a complete folder containing a number of Excel files? In that case the code of the source query starts with

[iduncanw]

Looks nice and simple, will have to try it. How does it work with multiple users. Assuming each user has permission to the Excel file on SharePoint, will they each be prompted for credentials the first time they connect to it?

[collontomlyn]

Great explanation--thank you! Will this also work if you want to change an existing pivot table (from Analyze in Excel) to another model on SharePoint?

[brentpearce]

Your info is timely as several of my customers are moving to SharePoint/OneDrive. Any thoughts on performance? I find SharePoint/OneDrive to be significantly slower. Any tricks?

[gavonak]

You can make this solution dynamic by putting the filename as a step.
Referencing the Filename step in the

[swadeshmondal]

Thanks for ur video. I have some other requirement, how xls file will sync from sharepoint to onedrive automatically with power query?

[diederikvankolfschoten]

Great trick, thanks for sharing. Is there also an easy way to reconnect to a folder of excel files after moveing to SP?

[RoyAliKhairan]

Hi, Sir! Is it possible to submit/save a document let say a pdf document to a specific forlder in Sharepoint?

[cheatvideos]

In onedrive Can I use folder url, because want each excel file come to folder to be added automatic to power BI dashboard

[patolobos]

Maybe I'm missing something but how this will work on Powerbi.com it will mean that a "Service Principal" acccount must hace access to that specific folder?