Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
franckster
Frequent Visitor

Azure AD oAuth request returns html page and not oAuth Code

Hi all,

 

I'm new to PBI and the AAD world, presently working on an Embedded App Owns Data POC for our company, to display custom dashboard for our clients within our application.

I've followed all the step to declare a PowerBI Native App and grant permissions in our Azure Active Directory tenant, got a client id, the oAuth API endpoint. I declared urn:ietf:wg:oauth:2.0:oob as a return url for now.

Since we developped our app in Ruby on Rails, I'm test riding the API with raw calls with the Restlet Client Chrome extension.

I'm following the instructions there : https://docs.microsoft.com/en-US/azure/active-directory/develop/active-directory-protocols-oauth-cod...

I am stuck on the first step. When I call POST on this url :

https://login.microsoftonline.com/"mytenantid"/oauth2/authorize?client_id="myclientid"&response_type...

I don't get a response with an AD access code but an html page that basically says "Connect to your application".

Any help will be greatly appreciated...

Thanks forward !

 

1 ACCEPTED SOLUTION

Replying to myself but will be useful for others too seeing the time I spent on the matter...

MS Support pointed me to this thread which solved my problem :

https://community.powerbi.com/t5/Developer/How-To-Get-embed-token-using-Get-Post-only/td-p/294475

I used Postman to try everything, making sure to pass the body of the Get Embed Token API POST calls as Raw / JSON (application/json) ( cf radio buttons underneath the Authorization/Headers/Body/Pre-request Script/Test tabs). Doing otherwise would set this particular API calls off for passing form-data.

Hope this helps !

Thanks again @v-ljerr-msft for your help !

View solution in original post

4 REPLIES 4
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @franckster,

 

Instead of using the Restlet Client Chrome extension, could you try using POSTMAN which is recommended for testing/debug purpose. For more details, you can refer to this similar thread. Smiley Happy

 

Capture.PNG

 

Regards

Thanks a lot for reaching out !

I had a PBI Support engineer on the phone Friday and we managed to get a report embedded using the .NET App Owns Data Project on Github.

The trouble was that you need to pass Client credentials to get the AD oAuth Access Token in the first place even for an App Owns Data scenario. And even though I read the doc a few dozen times, I never came across it.

Adam Saxton indeed mentions the "Master account" in one of his videos and the code does create variables for a username & password to be passed to AD.

We couldn't find it in the API doc when we looked up for the raw API call url nor in the App Owns Data source code either.

The engineer said he would get in touch with the folks over in Redmond and email me went the answer came.

I'll post it back here once I have it !

Replying to myself but will be useful for others too seeing the time I spent on the matter...

MS Support pointed me to this thread which solved my problem :

https://community.powerbi.com/t5/Developer/How-To-Get-embed-token-using-Get-Post-only/td-p/294475

I used Postman to try everything, making sure to pass the body of the Get Embed Token API POST calls as Raw / JSON (application/json) ( cf radio buttons underneath the Authorization/Headers/Body/Pre-request Script/Test tabs). Doing otherwise would set this particular API calls off for passing form-data.

Hope this helps !

Thanks again @v-ljerr-msft for your help !

@v-ljerr-msft
When i try to get Embed Token by sending Access Token i'm taking 403 Forbidden (step 3).  I'm sending data as raw and application/json .
Could you recommend something to me fix this problem ?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.