How to connect GitHub private repositories with Power BI

[LDevi2017]

Hello,

I am trying to connect GitHub private repository with Power BI desktop. When I try to pass the Web API key, then I am getting below error. 

That API Key is generated from GitHub personal access tokens

Using same key I can generate JSON file from Postman, it's working fine.

Can any one help me on this to connect GitHub private repository with Power BI desktop

Thanks in advance

[v-xinruzhu-msft · Accepted solution]

Hi @LDevi2017 

You can try the following solutions.

1.Connect Power BI to Private GitHub Repo — Smoother Consulting

Put your useraccount of the github to the username, then put the API key to the password.

2.You can try the following code.

let

    apiUrl = "my_api_url",

    token="my_api_key",

    options = [Headers=[#"Authorization"="Bearer " & token ]],

    result = Json.Document(Web.Contents(apiUrl , options))

in

    #"result"

You can also refer to the following link.

Solved: A web API key can only be specified when a web API... - Microsoft Fabric Community

rest - A web API key can only be specified when a web API key name is provided - Stack Overflow

Best Regards!

Yolo Zhu

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

[LDevi2017]

I have connected using web option  and selected basic user name as API Key

But after entered into power query result as below

Actually JSON file need to load from this link. Can we able to convert this to table.

Can I get any help

[v-xinruzhu-msft · Accepted solution]

Hi @LDevi2017 

You can try the following solutions.

1.Connect Power BI to Private GitHub Repo — Smoother Consulting

Put your useraccount of the github to the username, then put the API key to the password.

2.You can try the following code.

let

    apiUrl = "my_api_url",

    token="my_api_key",

    options = [Headers=[#"Authorization"="Bearer " & token ]],

    result = Json.Document(Web.Contents(apiUrl , options))

in

    #"result"

You can also refer to the following link.

Solved: A web API key can only be specified when a web API... - Microsoft Fabric Community

rest - A web API key can only be specified when a web API key name is provided - Stack Overflow

Best Regards!

Yolo Zhu

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

[LDevi2017]

Thanks for your reply.

When I try to connect with Power BI desktop, till the repo it's reading.

i.e https://api.github.com/repos/owner/repo

But it's not reading till joson file and I can see blank result.

Can you suggest me where I can check it exactly.

[v-xinruzhu-msft · Accepted solution]

Hi @LDevi2017 ,

Thanks for your quick reply, you can try to refresh the datasource,

Best Regards!

Yolo Zhu

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

[LDevi2017]

Hi Yolo Zhu,

I got the result on power query on yesterday once and again it shows blank result.

Can you suggest me what would be the reason and how can we solve.

Thanks,

Lakshmi

[LDevi2017]

Hi Yolo Zhu,

Thank you very much. It's working perfectly.

Thanks,

Lakshmi