Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 a...
Dataflows
General Question
Need Help
  • miguel's avatar
    miguel
    2 years ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

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.