Forum Discussion
Gateway set up with OneDrive
Need you advice here: 1. If it's possible to set up a gateway if my data source is on OneDrive? I am aware OneDrive doesn't need a gateway but it is teoretical question. 2. Are there any be...
HI v-xicai
"For your question1 , question2 and question3, to connect to the files located in OneDrive for Business , you need to use Web connector, pay attention to steps detail: Use OneDrive for Business links in Power BI Desktop."
I am trying the above and failing.
When select open in Excel my window look like this...
When click on "Copy path" my link is copied in the format:
C:\Users\aaaaaaa.bbbbbb\Downloads\DimCustomer 2.xlsx
Which is not the link to OneDrive but to a local copy.
I tried the "Copy link" too..
and the format of this is:
Is this a correct one?
Open in Excel online probably gives you the correct link as that's a public one which is not specified in the blog.