SOLVED

Excel "GetData" from file or web (OneDrive)

Copper Contributor

Hello! 

 

I am trying to import data from a shared file via OneDrive (into another shared file via OneDrive).

 

I have tried two different options:

 

1) Using "GetData" from a file. This works if I am using my computer. The moment I use another computer with access to the same Drive, I have to re-link the data from the new computer to the same file. I even changed the names of the multiple computers to the same name, so they have the same "filepath". It is still not working (without re-linking the same workbook when on a different computer).

 

2) Using "GetData" from a excel link on OneDrive. I tried multiple links, the one that seems to work is "downloading" the file, and copying the download link. This only works until the file is changed and a new link makes the old download link obsolete.

Please advise on how I can use either methods to link the data, without having to update the links (or files) every time the sheet is opened from another computer, etc.

 

Thank you so much! I have spent countless hours trying to resolve this issue :(

 

 

9 Replies

Hi @emilychang87 

 

@Wyn Hopkins has this VIDEO that might help

 

Cuong

Microsoft

 

Can you please relink? I am getting a: 504 Gateway Time-out message....

Thank you! @cuong 

Strange, try this direct link to YouTube instead

https://youtu.be/gJF2e_43FRY

@Wyn Hopkins Thanks for the link! I went to the source file and clicked "copy link to clipboard", used the link to fetch the data from web, and received the following error:

 

"Unable to Connect
We encountered an error while trying to connect.

Details: The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server."

 

This is what my link looks like copied from the source file:

https://d.docs.live.net/bb9887e258ca6c3a/GSD%20(M%20One%20Drive)/Order%20Processing/Label%20Request%...

 

Thanks,

 

Emily

best response confirmed by emilychang87 (Copper Contributor)
Solution
Hi Emily

If you’re using OneDrive personal then this link should help ( my solution was for OneDrive Business)

https://community.powerbi.com/t5/Power-Query/PowerBI-support-for-OneDrive-Personal-as-data-source/td...

SO sorry for the late response... was out of town. Your solution worked! Thank you so much! You saved my excel life :) @Wyn Hopkins 

Glad I could help
1 best response

Accepted Solutions
best response confirmed by emilychang87 (Copper Contributor)
Solution
Hi Emily

If you’re using OneDrive personal then this link should help ( my solution was for OneDrive Business)

https://community.powerbi.com/t5/Power-Query/PowerBI-support-for-OneDrive-Personal-as-data-source/td...

View solution in original post