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

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

raksha_v — Thu, 06 Apr 2017 18:13:33 GMT

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.How can I configure SSL (HTTPS)?

Thank you!

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

v-qiuyu-msft — Fri, 07 Apr 2017 08:56:01 GMT

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

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

pranim — Fri, 30 Jun 2017 22:54:35 GMT

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

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

MBaillo — Fri, 03 Nov 2017 08:55:44 GMT

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?

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

aimcar — Mon, 20 Nov 2017 18:12:41 GMT

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

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

aimcar — Mon, 20 Nov 2017 18:17:42 GMT

Hi Qiuyun,

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

Thanks,

Aimee

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

aimcar — Tue, 21 Nov 2017 00:06:51 GMT

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

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

aimcar — Tue, 21 Nov 2017 00:51:27 GMT

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

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

BIyogi — Mon, 09 Apr 2018 17:44:43 GMT

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.

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

Anonymous — Thu, 10 Jan 2019 12:12:41 GMT

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

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

Anonymous — Wed, 15 May 2019 09:24:14 GMT

I am getting the same problem.

I am using Edge browser (also a problem in Chrome)
have an https:// SharePoint URL
have no trouble connecting using the same credentials in Power BI Desktop.

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

samuelpereira — Tue, 11 Feb 2020 17:17:20 GMT

With me the error was only noticed when using Microsoft browsers. Switch to Google Chrome and it will probably work. I was able to change data sources with OAuth normally by connecting to the Power BI Service through the Google Chrome browser.

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

Anonymous — Thu, 05 May 2022 18:37:00 GMT

I was having the exact problem using Firefox. I switched to Microsoft Edge. I was able to change data sources with OAuth2 normally by connecting to the Power BI Service through the Microsoft Edge browser.

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

YohanEisenbah — Mon, 08 Jan 2024 17:35:27 GMT

I successfully resolved this issue by checking the following checklist:

Enable pop-ups in your browser.
If you are not using Microsoft Edge and the error persists even after enabling pop-ups, try using Microsoft Edge.

I found this checklist on this post.

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

Anonymous — Wed, 13 Mar 2024 10:59:59 GMT

I am facing this problem owing to OAuth 2.0 please help

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

aadib20997 — Mon, 03 Feb 2025 23:05:54 GMT

Since I am using my work organisation's account. In my case when I changed my privacy settings from none to organisation it worked for me.