Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Connecting to OneDrive excel file

Hello,   I'm trying to connect to a onedrive excel file via the "web" data source. I followed these instructions: https://www.youtube.com/watch?v=t4TzHu8THoA   but am getting this error when try...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Did you try to delete ‘/$Value’ in the advanced editor?

This is my connection query and I import the excel file from OneDrive for Business successfully.

let
    Source = Excel.Workbook(Web.Contents("https://qiuyunus-my.sharepoint.com/personal/xxxx/Documents/FileName.xlsx"), null, true),
    Sales_Sheet = Source{[Item="Sales",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sales_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Product", type text}, {"Sales", Int64.Type}, {"Region", type text}})
in
    #"Changed Type"

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.