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
