Problem with credentials - OAuth2

[DarrenWheatley]

We've managed to configure our PowerBI dashboard site to allow refresh of a report that uses data from SQL servers (not a problem) and SharePoint lists (caused a few headaches).  We solved the problem by using OAuth2 authentication.  The problem is that I've published another report using more or less the same datasources (same SQL but the SP content is on a different team site) but when trying to set the credentials to Oauth2, we're only getting two options (anonymouse and windows) in the drop box.  I've seen this problem flagged before (though there didn't seem to be a conclusive answer published) but I think the original respondant couldn't get any of their reports to work.

Is there something you have to configure in Desktop perhaps that allows Oauth2 to be used?

[Anonymous]

Hi @DarrenWheatley ,

Check the document below and see if it helps.

https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[DarrenWheatley]

I'm afraid not.  We still have one file that allows oauth2 and one that doesn't.  I've tried all 4 security settings from the Desktop file (where I think the problem must be) to no avail

[DarrenWheatley]

I thought I had this.  Original url for the SP site was  http:// but all the urls for the working report were https:// so I made the change and got the option to use oauth2.

All good, or so I thought.  The scheduled update has failed twice since then, apparently because of an internal service error.

Time to raise a ticket

Also ctrl c/v doesn't seem to work in this text window.

[DarrenWheatley]

PS how on earth do you raise a ticket?

I've clicked on the ticket option but it's telling me I need an admin account to access it.

Also, whenever I try to sign in on the support page I'm taken back to my powerbi home page and it all goes around again.

[Anonymous]

Hi @DarrenWheatley ,

Sorry for the delay.

Please check the blog below about how to create a support ticket.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830....

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[DarrenWheatley]

Okay, so I followed your link, landed on the page but wasn't signed in.

If I click on the sign in option, it takes me back to my powerbi homepage, as I said before.

If I don't sign in I can click on the button to raise a ticket but then it asks me to select an account.  When I do this I'm told I need admin approval to go any further.

I have a powerbi pro license, so I don't know why this should be an issue.

[DarrenWheatley]

PS if you need me to illustrate any of this with screen images, is there somewhere you can upload them to?

[Anonymous]

Hi @DarrenWheatley ,

Once you submit the ticket, you will get an email from support@mail.support.microsoft.com. Someone from the Microsoft support team will contact you.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[DarrenWheatley]

as I have already explained, I am UNABLE to submit a ticket, due to the reasons outlined above

[DarrenWheatley]

PPS and I do have an admin account for the system (2 in fact) but using this doesn't make any difference - I still get the message

Need admin approval

powerbi.microsoft.com

powerbi.microsoft.com needs permission to access resources in your organisation that only an admin can grant. Please ask an admin to grant permission to this app before you can use it.