Power BI web page data source and Reporting REST API

[Armin Lengauer]

Hi community, 

I have tried to configure Power BI's web  page data source to connect to the Reporting REST API. I am not able to successfully configure basic authentication, so that this works.
I only have the workaround to create an authorization token in the REST APIs Swagger and then set the header for the web page data source accordingly. But this is not a comfortable way for report creators let alone business users. 

Does anyone know how to connect to the Reporting API with a more user-friendly way (e.g. password dialog for basic authentication) without programming ?   

[Madhava.Alampally]

Hi Armin,

In General, Any REST API/Endpoint which provides the access token accepts the Authorization header as part of the request headers. 

Authorization header is  Base64 encoding constructed using basic authentication details (username and password).

And, It's client's (Swagger /Postman Rest Client /Chrome Advanced Rest Client /BI Tool which provides the Rest APIS integration) responsibility to provide the place holder to the user to capture the basic authentication and construct the Base 64 encoded Authorization header to pass with the request to get the Access Token. 

Once we get the access token, we can use it in the header to access any of the Reporting APIs to get the reporting data as a data source.

Swagger and Rest Clients provide the palace holder to capture the Basic authentication details and pass the Authorization header automatically as part of the request to generate the access token.

So, Can you please check from the Power BI side to capture the basic authentication details and generate the Authorization Header to get the access token. 

Thanks & Regards,

Madhava

[Armin Lengauer]

Hi, 

in the meanwhile I had some time to further explore how Power BIs more user friendly basic authentication dialog, which creates the Base 64 encoded Authorization header,  interacts with the REST API. It sends the authorization header with a HTTP GET request whereas the CASM REST Reporting API expects a POST request for the /access endpoint. 

I will also ask this in the Microsoft Forums but currently I see no user-friendly way for authorizing against CASM REST API from Power BI. 

regards, 

Armin