Reply
Frequent Visitor
Posts: 3
Registered: ‎03-01-2017

Data Source Credential error upon using OAuth 2.0 to Refresh Exchage Server Online data

Hello,

 

I am trying to Schedule Refresh for my dashboard which gets data from Exchange Server Online. The settings I am using are:

Gateway Connection: Direct Query

Data Source Credentials: OAuth 2.0

 

I see the following error with respect to the Data Source Credentials:

Failed to update data source credentials.

You need to use SSL (HTTPS) when you use OAuth 2.0 authentication.InkedSSL error.jpgHow can I configure SSL (HTTPS)?

 

Thank you!

 

 

 

Moderator
Posts: 9,145
Registered: ‎03-06-2016

Re: Data Source Credential error upon using OAuth 2.0 to Refresh Exchage Server Online data

Hi @raksha_v,

 

When you use Microsoft Exchange Online data source in desktop, can you enter credential successfully? When you enter credential in service, please use Fiddler to capture http(s) traffic and share .saz file here.  

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor
Posts: 26
Registered: ‎06-04-2017

Re: Data Source Credential error upon using OAuth 2.0 to Refresh Exchage Server Online data

I am experiencing the same problem and moreover, my file path  has https and its still giving me this error. The url works fine when i use it in Power BI Desktop to create reports.  Please help me find the solution.

 

Thanks,

Pranitha

 

InkedCapture_LI.jpg

New Member
Posts: 1
Registered: ‎11-03-2017

Re: Data Source Credential error upon using OAuth 2.0 to Refresh Exchage Server Online data

Good morning,
I get the same error: 

"You need to use SSL (HTTPS) when you use OAuth 2.0 authentication."
The link I am using is a https and other colleagues can use the OAuth and it works.  Any solution?

Frequent Visitor
Posts: 6
Registered: ‎11-20-2017

Re: Data Source Credential error upon using OAuth 2.0 to Refresh Exchage Server Online data

I'm having the same error.  Is there a solution for this yet?

Frequent Visitor
Posts: 6
Registered: ‎11-20-2017

Re: Data Source Credential error upon using OAuth 2.0 to Refresh Exchage Server Online data

Hi Qiuyun,

 

Where can I get Fiddler for the Power BI Service?  Is it in a dropdown?

 

Thanks,

 

Aimee

Frequent Visitor
Posts: 6
Registered: ‎11-20-2017

Re: Data Source Credential error upon using OAuth 2.0 to Refresh Exchage Server Online data

I believe I've found a solution.  Try the instructions here which gets Kusto data through an M query instead of through the Kusto option under Get Data:

 

https://kusto.azurewebsites.net/docs/tools/tools_powerbi.html

Frequent Visitor
Posts: 6
Registered: ‎11-20-2017

Re: Data Source Credential error upon using OAuth 2.0 to Refresh Exchage Server Online data

Ok, the previous M Query attempt did not fix the problem.  I still get this error:

 

KustoPbiRefreshProblem.png

 

Frequent Visitor
Posts: 2
Registered: ‎12-16-2016

Re: Data Source Credential error upon using OAuth 2.0 to Refresh Exchage Server Online data

I'm also getting the same issue when trying to refresh Kusto data. Has anyone found a solution yet?

 

My scheduled refreshes are failing. When I try and "Edit Credentials" under Data Source Creditentials in the Dataset tab, I get an authentication dialog box. When I click sign-in, it creates a lengthy URL, yet the redirected link merely generates a pop-up that asks if I want to close the window. 

 

Any help is appreciated. 

New Member
Posts: 1
Registered: ‎01-10-2019

Re: Data Source Credential error upon using OAuth 2.0 to Refresh Exchage Server Online data

The problem can be easily solved by using a different browser. Microsoft Edge is recommended for using Power BI service.