cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Gordon2 Member
Member

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

Picture1.png

4. What happened to OAuth authentication with Sharepoint?

Why it is not available?

Capture1.PNG

11 REPLIES 11
Community Support Team
Community Support Team

Re: Gateway set up with OneDrive

Hi @Gordon2 ,

 

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.

 

4.png

 

 

 

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

 

Best Regards,

Amy

 

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

Gordon2 Member
Member

Re: Gateway set up with OneDrive

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.

Capture3.PNG

When select open in Excel my window look like this...

Capture4.PNG

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

and the format of this is:

https://myorg-my.sharepoint.com/:x:/r/personal/username/Documents/test/DimCustomer%202.xlsx?d=wd6325...

Is this a correct one?

 

u02cm62
Advisor

Re: Gateway set up with OneDrive

Open in Excel online probably gives you the correct link as that's a public one which is not specified in the blog.

Gordon2 Member
Member

Re: Gateway set up with OneDrive

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 : Web

username: domain/username

password: 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?

 

u02cm62
Advisor

Re: Gateway set up with OneDrive

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.

u02cm62
Advisor

Re: Gateway set up with OneDrive

It says your creds are incorrect, also make sure the id and password are correct.  I assume that part is correct as that's obvious in the error.

Gordon2 Member
Member

Re: Gateway set up with OneDrive

ya, that was a typo. Still have this error. 

No idea where the root cause is. Double checked the account name in Active Directory.

Gordon2 Member
Member

Re: Gateway set up with OneDrive

Is that can be caused by PingID normally use as additional security when signing in to intenal services?

u02cm62
Advisor

Re: Gateway set up with OneDrive

Since one drive and excel online use Azure Active Directory, I would think it would be email as your id.  Just thinking out loud...here.

 

PingID could block it yes.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors