- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Power BI Service - Connect to Web API with advanced Header
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-05-2023 06:38 AM | |||
08-11-2023 07:04 PM | |||
03-11-2024 05:55 AM | |||
02-27-2025 04:19 AM | |||
01-04-2024 04:50 AM |
User | Count |
---|---|
3 | |
3 | |
1 | |
1 |