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 benefits from that? When it make sens? 3. When setting up a new data source within the enterprise gateway what data source type is relevant for OneDrive?Sharepoint, Web, File ? 4. What happened to OAuth authentication with Sharepoint?Why it is not available?

Hi Anonymous , 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. If your dataset contains not only cloud data source (such as OneDrive for Business ) but also the on premise data source, you need install and configure data gateway, and add the web data sources to gateway. For the Data Source Type, you need to choose Web. See more:https://docs.microsoft.com/en-us/power-bi/service-gateway-data-sources#add-a-data-source. Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources. For your question4, you may refer to the case https://community.powerbi.com/t5/Power-Query/sharepoint-gateway-error-not-showing-Oauth-in-Datasource-Setting/td-p/430316. Best Regards,Amy If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.xlsxWhich is not the link to OneDrive but to a local copy. I tried the "Copy link" too..and the format of this is:https://myorg-my.sharepoint.com/:x:/r/personal/username/Documents/test/DimCustomer%202.xlsx?d=wd63254124802408792791edb9423e569&csf=1&e=duGzmuIs 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.

So, link copied from Excel Online is a little bit different: https://myorg-my.sharepoint.com/:x:/r/personal/username/_layouts/15/Doc.aspx?sourcedoc=%7BD6325412-4802-4087-9279-1EDB9423E569%7D&file=DimCustomer%202.xlsx&action=default&mobileredirect=true&cid=53e19528-b115-4311-bd93-400edf596bb9 I then, tried to add new data source to the enterprise gateway I had installed:data source type : Webusername: domain/usernamepassword: domain password (windows)authentication: windows and received this error. Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details Activity ID: cac000c6-4ed3-4c7f-ad8a-1e2ccc57c89c Request ID: 26bb7da1-0ca3-6984-92d9-27a5611d7f34 Cluster URI: https://wabi-us-north-central-redirect.analysis.windows.net Status code: 400 Error Code: DMTS_PublishDatasourceToClusterErrorCode Time: Tue Aug 06 2019 10:50:12 GMT+0200 (Central European Summer Time) Version: 13.0.10315.184 bw-on-premise-gtw: Invalid connection credentials. Underlying error code: -2147467259 Underlying error message: The credentials provided for the Web source are invalid. (Source at https://myorg-my.sharepoint.com/:x:/r/personal/username_layouts/15/Doc.aspx.) DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.CredentialError.DataSourceKind: Web Microsoft.Data.Mashup.CredentialError.DataSourcePath: https://myorg-my.sharepoint.com/:x:/r/personal/username/_layouts/15/Doc.aspx?sourcedoc=%7BD6325412-4802-4087-9279-1EDB9423E569%7D&file=DimCustomer%202.xlsx&action=default&mobileredirect=true&cid=53e19528-b115-4311-bd93-400edf596bb9 Microsoft.Data.Mashup.CredentialError.Reason: AccessForbidden Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"Web","path":"https://myorg-my.sharepoint.com/:x:/r/personal/username/_layouts/15/Doc.aspx?sourcedoc=%7BD6325412-4802-4087-9279-1EDB9423E569%7D\u0026file=DimCustomer%202.xlsx\u0026action=default\u0026mobileredirect=true\u0026cid=53e19528-b115-4311-bd93-400edf596bb9"}] Microsoft.Data.Mashup.MashupSecurityException.Reason: AccessForbidden Troubleshoot connection problems New data source https://myorg-my.sharepoint.com/:x:/r/personal/username/_layouts/15/Doc.aspx?sourcedoc=%7BD6325412-4802-4087-9279-1EDB9423E569%7D&file=DimCustomer%202.xlsx&action=default&mobileredirect=true&cid=53e19528-b115-4311-bd93-400edf596bb9 mydomain\username •••••••The same happens when previous link was used. Has any one succeed with setting up OneDrive data source for a gateway?

Maybe this was a typo in your comment, but it's domain\username not domain/username and that does make a difference. Try that and post your results.

Gateway set up with OneDrive | Microsoft Fabric Community

11 Replies

v-xicai
Community Support
7 years ago
Hi Anonymous ,

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.

If your dataset contains not only cloud data source (such as OneDrive for Business ) but also the on premise data source, you need install and configure data gateway, and add the web data sources to gateway. For the Data Source Type, you need to choose Web. See more:https://docs.microsoft.com/en-us/power-bi/service-gateway-data-sources#add-a-data-source.

Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

For your question4, you may refer to the case https://community.powerbi.com/t5/Power-Query/sharepoint-gateway-error-not-showing-Oauth-in-Datasource-Setting/td-p/430316.

Best Regards,
Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Anonymous
  Not applicable
  7 years ago
  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:
  https://myorg-my.sharepoint.com/:x:/r/personal/username/Documents/test/DimCustomer%202.xlsx?d=wd63254124802408792791edb9423e569&csf=1&e=duGzmu
  Is this a correct one?
  - Anonymous
    Not applicable
    7 years ago
    Open in Excel online probably gives you the correct link as that's a public one which is not specified in the blog.
v-xicai
Community Support
7 years ago
Hi Anonymous ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy
- Anonymous
  Not applicable
  7 years ago
  It's not yet resolved. With email address it's not working too. I have no idea which way to go. Let's keep it open.

Forum Discussion

Gateway set up with OneDrive

11 Replies

Related content

OneDrive Refresh

Linking to SharePoint, NOT OneDrive

OneDrive Refresh

OneDrive synchronization instantly

OneDrive refresh via Data Gateway