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

Data Source Credentials Issue

I'm pretty new to Power BI but have been able to create a report in Power BI Desktop  and then publish to our companies free Power BI.  When I try to schedule a daily refresh, since we're using the free version for proof of concept, I get an error that I need to add my credentials, but when I try there is no option for SharePoint Online.  When I open Power BI Desktop and click refresh it works just fine.  I've attached a couple of graphics to help.

 

Datasource: SPOL

 

Thanks,

D

 

PowerBI-CredentialError1.pngPowerBI-CredentialError2.png

 

10 REPLIES 10
Moderator v-yuezhe-msft
Moderator

Re: Data Source Credentials Issue

Hi @DarenD2,

I am able to reproduce your issue that oauth option is missing from the authentication method, and we are not able to set schedule refresh for sharepoint online list currently. I have reported this issue internally, I will post back once I get any updates.

1.png

 

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DarenD2 Frequent Visitor
Frequent Visitor

Re: Data Source Credentials Issue

Thank you Lydia!  I'll stand by.  Smiley Happy

DarenD2 Frequent Visitor
Frequent Visitor

Re: Data Source Credentials Issue

Lydia have you heard anything back yet? Would like to get this resolved for my CEO soonest.

 

Thanks

D

Moderator v-yuezhe-msft
Moderator

Re: Data Source Credentials Issue

Hi @DarenD2,


OAuth is shown in authentication list as follows, please check if you can schedule refresh for your dataset.1.PNG

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DarenD2 Frequent Visitor
Frequent Visitor

Re: Data Source Credentials Issue

Lydia,

   I don't have the "OAuth2" option in my dropdown.

 

Thanks,

D

Moderator v-yuezhe-msft
Moderator

Re: Data Source Credentials Issue

Hi @DarenD2,

Have you created a new report and published it to Service?

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DarenD2 Frequent Visitor
Frequent Visitor

Re: Data Source Credentials Issue

Lydia,

  so I have to delete the reports I've already created and start new ones?

Moderator v-yuezhe-msft
Moderator

Re: Data Source Credentials Issue

Hi @DarenD2


Please re-create a small report, publish it to Service and check if the OAuth2 is listed. Based on mllopis's comments in this issue,  SharePoint Online authentication issues have been resolved. However, some users are still running into the "getting stuck" on authentication screen,the team is working on a fix and will share another update as soon as they have an ETA for resolution.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Moderator v-yuezhe-msft
Moderator

Re: Data Source Credentials Issue

Hi @DarenD2,

Are you able to refresh your dataset after republish reports?

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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
Top Kudoed Authors