My Excel file is in the cloud! Why isn't refresh working in Power BI???

Pulling data from an Excel document in the cloud? Is your Power BI dataset not refreshing? Adam looks at why this could be the case and how to get it working.


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #Excel #GuyInACube

[ericgibson]

Seems like this is a common problem that causes headaches for casual users. MS should make Power BI smart enough that it surfaces a prompt if it recognizes that the excel file is synced to onedrive and offer to use the web version instead of the local file.

[nithinmadhavan]

This is a very common problem among users who face this issue. Even some time developers aren't sure about the fix. Great video which will help the Power Bi community. Thanks Adam.

[hqcuywg]

I've come back to this video SO many times in the past year. You guys are the best.

[bryanewington]

Huge thanks for this. I have spend many a report trying to resolve this and it is such a simple issue on the face of it. Yet, it is so obvious people will probably not even think of it. I am one of those people. Has now helped me out massively so have Subscribed to your channel which is the least I can do to show my appreciation!

[anshulgrover]

We solved the exact same problem 3 months back.. First time there is one guy in a cube video I know the process too(felt so gooood ❤)
Sent it to the team and they patted their back 👏🏼
Anyway, thanks for making these amazing videos 😇

[vladimirostroukhov]

Excellent video! Thanks Adam! I was not aware that PBI can reference the files in the cloud. Watching the video, it made realize how tough it was to connect to any excel files saved in the cloud. It should be that difficult. How intuitive is to click on "Copy path" and then use that in connecting to the Web. Microsoft Office should make it more user-friendly. Now it looks like to much investigation.

[djgeorgecostanza]

Thanks dude you've helped me more than the Power Bi team themselves much appreciated

[michaelbarilla]

Great video. I learned so much. really appreciate the support you and Patrick provide.

this def should be easier per other comments. one note on the url: "copy link" wont be as clean for everyone where you can just trim the end of the text off and get a working url. in that case, rather than selecting "copy link" after the elipsis, you may instead have to scroll down and select "more" then "details". then a pane on the right side opens, scroll down to the line "Path", then copy the path. i think this is your true URL and how i was finally able to get my darned refresh scheduled.
thanks

[nouamanebrinssi]

Thks for the video, i my case i dont have Excel like you version, i'm in local one, so to get the file path : in SharePoint or OneDrive > 3 dots in the file > Details > in the panel at the right select More Details > Copy Path icon :)

[ljsdwl]

I Love you, after spending an hour trying to figure out why it wasn't working I found your video.

[joeydisessa]

Such a CLUTCH video, been search all over the web for this solution. THANK YOU

[vinothkathiresan]

Thank you for this video. Extremely helpful. I am new to PowerBi and was struggling with data refresh for the past two months. This solution (ideal method against) worked .

[juanaldao]

Excellent !! Many thanks!! I searched all over the internet and couldn't find an answer. Thanks Adam!

[joebashour]

This was making me go bananas for the past 2 days! Thanks a TON

[therealcslewis]

Such a helpful video!! I searched high and low to try to fix this issue and this resource is spot on and well laid out! you

[DeepakPrajapati-ipxj]

Great video, thanks man i was struggling to clear this error from last 1 week but you made it so easy.

[Romi]

I have been struggling with this issue for over a week - realised it was pointing to my C:/ few days ago and then I was copying the URL from my online version of the file but was still not working! Going to try this fix tomorrow, thank you!!!

[TitansLacrosse]

Literally JUST worked with a customer on this today - thanks Adam!

[RawitsaraSuwannimit]

thank you so much. This video saves my life.

[rdaleprice]

Great video! What would need to be modified to connect to a Get Data, FOLDER with multiple Excel files that are combined by Power BI?