Power BI Service - Connect to Web API with advanced Header

[bennet_mc]

Hello everyone,

I'm currently wondering how I can connect to the GitLab API through Power BI Service when creating a dataflow. As far as I know, in Power BI Service there isn't an interface for adding advanced headers to specify the GitLab personal access token:

In Power BI Desktop, you have the option to add advanced headers for access tokens, but how do I do this in Power BI Service to create a dataflow connecting to the GitLab API? There's also an option to directly get the data through an empty query, but I'm not sure how to do that.

I would appreciate any form of help.

Thank you!

[miguel · Accepted solution]

You can either manually create your M Script through a blank query or in the advanced editor or use another application (like Power BI Desktop or Excel) to create the query and copy:paste it into the Dataflow experience of your choice (link below on how to do that).

https://learn.microsoft.com/en-us/power-query/share-query

[v-yilong-msft]

Hi @bennet_mc ,

As you said, there is no support on Power BI Service to add advanced headers for authentication to connect to the GitLab API.

I think you can start by performing the following steps on Power BI Desktop:

1. Open Power BI Desktop and go to > Web Get Data.

2. Enter the GitLab API URL and click OK.

3. In the Navigator window, select Advanced and add the necessary headers, including the GitLab Personal Access Token.

Then you can just upload the Desktop report to the Service side.

Also, if you can, I would suggest that you post to the Power BI Service forum as well, and there will be professionals there to answer your questions as well.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.