Forum Discussion
Helper IIBuild OData service with authentication for PowerBI
Community ChampionFor Organization account, that requires an O365 username and password, so basically Azure AD authentication. The WebAPI key and Data Marketplace (correct, Azure Data Marketplace) are both "secret key" authentication. Probably something along the lines of: http://bitoftech.net/2014/12/15/secure-asp-net-web-api-using-api-key-authentication-hmac-authentication/
This links might have some useful bits of information:
https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-authenticate-a-web-app/
I'm thinking Basic authentication is probably a good way to go.
Helper IIThanks smoupre,
Basic authentication over TLS is likely easiest, but I'm not sure it will meet the security requirements of the organization.
That HMAC link you included looks very useful. It talks about creating the message digest and says that the client and server have to calculate the digest the same way.
So I'm wondering how the PowerBI OData client uses the WebAPI key, and is there a standard or any docs on how it does that? The links you provided after that are how custom clients can authenticate to the PowerBI services, but this case is the other way around - PowerBI is the client, my OData endpoint is the service.
Thanks again.
Mike
- Greg_Deckler
I am generally not a fan of cross-posting but you might want to post a link to this thread in the Developers forum as you might get some better traction in that forum. Or, perhaps a mod could move this over to the Developer forum? While your question is definitely about integrations with files and services, I think that the question is much more of a developer question than what people generally post to this forum.
Only so much I can help as I do not do a ton of custom development.