cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
raksha_v Frequent Visitor
Frequent Visitor

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!

 

 

 

9 REPLIES 9
Moderator v-qiuyu-msft
Moderator

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.
pranim Regular Visitor
Regular Visitor

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

MBaillo New Member
New Member

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?

aimcar Frequent Visitor
Frequent Visitor

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?

aimcar Frequent Visitor
Frequent Visitor

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

aimcar Frequent Visitor
Frequent Visitor

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

aimcar Frequent Visitor
Frequent Visitor

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

 

BIyogi Frequent Visitor
Frequent Visitor

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. 

Highlighted
PaulEskes New Member
New Member

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.