Access OData .Net Core API from PowerBI portal

Question

We implemented OData Api with Asp.Net Core App (.Net 6). We want to authorize the access with AAD and the OData Connector. Inbetween the Api we used AddJwtBearer Middleware with tenant clientid , clientsecret etc. per documentation. We tried a customer connector like this:

section PQExtension1;
[DataSource.Kind="PQExtension1", Publish="PQExtension1.Publish"] shared OpenPlatform.Feed = Value.ReplaceType(PQExtension1Impl, type function (url as Uri.Type) as any);
PQExtension1Impl = (url as text) => let source = OData.Feed(url)
in source;

PQExtension1 = [ Authentication = [ Aad = [ AuthorizationUri = "https://login.microsoftonline.com/common/oauth2/authorize", Resource = ... ] ], Label = Extension.LoadString("DataSourceLabel") ];
...

This works in PowerBI Desktop. As uncertified Custom Connectors are not supported in PowerBI portal we cannot use it. In PowerBI Portal using Organizational Account with standard OData Connector we get the error: This credential type is not supported.

Is there a way to authorize access to our API with AAD at app.powerbi.com? We tried OAuth but didn't get it running. Could you provide an example what we have to code in our API to get it working?

Answer 1

Thanks for you answer. This really clarifyed the auth error and brought me a big step further.

My mistake was, that I tested on local machine and PowerBI tries to use the request url as AAD service principal. So I put my test into the cloud and changed the Application ID Url of our App Registration in AAD and it worked with PowerBI Desktop.

On the other hand I didn't get it running at app.powerbi.com. I'm in contact with PowerBI support on this.

Thank you very much for your help!