Skip to main content
AmigoFish

Stop Connecting Power Query to OneDrive Files Like This

From Leila Gharani Β· Β· 4 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

Connect Power Query to OneDrive and SharePoint files so refresh works for everyone. πŸ‘‰ Black Friday is coming up. Our best offer of the year goes to newsletter subscribers first. Sign up here so you don’t miss it: https://link.xelplus.com/yt-d-newsletter

πŸŽ“ Master Excel Power Query (500,000+ enrolled in our courses): https://www.xelplus.com/course/excel-power-query/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=power-query&utm_content=power-query-onedrive-links

When you connect through File Explorer, Power Query saves the path on your computer. Your colleague's path is different, so their refresh fails. I show you how to connect with the web link instead, for Excel files and text files, and how to switch queries you already built.

βœ… Good to know Use Copy Path, not Copy Local Path. Then delete ?web=1 at the end of the link. This works for OneDrive for work or school and SharePoint. Personal OneDrive links work differently. In the SharePoint Details pane, press End to jump straight to Path. If the copied link ends in ?web=1, delete that too. The first time you connect, sign in with your work account.

⏱️ Chapters 00:00 Why refresh fails for your colleague 00:31 Copy the OneDrive or SharePoint link 00:44 Connect to the Excel file with the link 00:59 Delete ?web=1 from the link 01:35 Fix queries you already connected 01:51 Change Source in Data Source Settings 02:17 Connect to a text or CSV file on SharePoint 02:31 Copy the direct link from the Details pane 02:49 Paste the link into From Text/CSV 03:44 Fix "credentials are invalid" after a password change

πŸŽ“ Power Pro Bundle (Power Query, Power Pivot & DAX, and Automate): https://www.xelplus.com/course/power-excel-bundle/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=power-pro-bundle&utm_content=power-query-onedrive-links

🏒 Training your team? https://www.xelplus.com/business-customers/

➑️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

βœ‰οΈ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter

🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani

#excel #powerquery #sharepoint

Back to Leila Gharani Β· Report a problem