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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
wikap
New Member

Connect to Dynamics 365 on-premise using oAuth (client appid / secret /username / password)

Hi Community

I'm trying to connect Power BI to a on-premise Dynamics 365 Sales organisation. I need to authenticate using a Application user (works fine with my Kingsway Adapter and a developer friend of mine has coded a custom connector which also works fine). Is this possible sending all information in the oData URL og another smart way (so I don't have to rely on the custom connector)?

 

I have access to the following information but can't see how to authenticate with this when I connect to Dynamics 365 using either oData or the Dataverse connector?

  

{
"odata": "https://URL_A.com/api/data/v9.0/",
"token_url": "https://URL_B.com/adfs/oauth2/token",
"client_id": "some guid",
"client_secret": "some secret",
"username": "some ad username",
"password": "som ad password"
}

 

Please tell me if I can do this without a CUSTOM data connector (which does not work through the Gateway when publishing reports).

 

Thanks in advance for reading my post (please tell me if I need to move it to another location in this community)

 

/Henrik

WIKAP

0 REPLIES 0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors