Forum Discussion

Copper Contributor

Sep 16, 2019

Solved

Excel "GetData" from file or web (OneDrive)

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 ...

excel

Excel for web

GetData

Wyn Hopkins
Sep 19, 2019
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-p/129125

emilychang87

Copper Contributor

Sep 17, 2019

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

Thank you! cuong

cuong

Microsoft

Sep 17, 2019

Wyn Hopkins can you help?

Wyn Hopkins
MVP
Sep 17, 2019
Strange, try this direct link to YouTube instead

https://youtu.be/gJF2e_43FRY
- Wyn Hopkins
  MVP
  Sep 17, 2019
  And an article here.... https://ssbipolar.com/2018/10/29/power-query-connecting-to-excel-workbooks-in-sharepoint-online/
  - emilychang87
    Copper Contributor
    Sep 18, 2019
    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%20Form%20Pivot.xlsx
    
    Thanks,
    
    Emily