topic Loading data issue of GitHub API data in Developer

Loading data issue of GitHub API data

sameer260 — Wed, 12 Jul 2023 14:36:56 GMT

Hi,

I have a requirement of getting dynamic API url data from GitHub to Power BI. The requirement is getting all the tfsec job failures in all the repos(nearly 1000 repos) and visualzing the count to end user. By using invoke function in Power query I am getting them loaded to Power query but I am unable to get the same data to Power BI desktop (and also it is loading forever). Kindly advise if there is better way of plling GitHub API data into Power BI desktop.

Facing the above issue while loading.

We were able to pull the data of repos, but we are trying to pull Jobs corresponding to the different Run_ids of Repos as shown below. We needed to check and filter considerably more amount of jobs for this. Kindly advise.

https://api.github.com/repos/{owner_name}/{repo_name}/actions/runs/{Run_ids}/jobs

We hit the error when we try to pull a good amount of rows, but it doesn't happen when we pull just a few rows

Re: Loading data issue of GitHub API data

Anonymous — Wed, 12 Jul 2023 06:25:40 GMT

Hi @sameer260 ,

According to your description, it seems that you're facing an issue when connecting to the GitHub API in Power BI Desktop. The error you're encountering is related to the "Microsoft.Mashup.Engine.Interface.ResourceForbidden" exception. This error might be caused by issues with the credentials used to authenticate or the data source itself rejecting the request coming from Power BI Desktop. To resolve this issue, you can try the following steps:

Clear the credentials for the data source from Power BI Desktop and try connecting again.
If the issue persists, you might need to check the GitHub API access settings and ensure that your credentials have the necessary permissions to access the data.

In addition, you can follow the steps below to load data from the GitHub API in Power BI Desktop:

Open Power BI Desktop and click on Get Data from the ribbon on the Home tab
Select Web from the list of data sources.
In the From Web window, enter the GitHub API URL you want to connect to (e.g.,https://api.github.com/users/{username}/repos).
Click OK to connect to the GitHub API
Power BI Desktop will load the data from the API, and you can use the Navigator to select the tables or entities you want to import.

Best Regards

Re: Loading data issue of GitHub API data

sameer260 — Wed, 12 Jul 2023 12:49:26 GMT

https://api.github.com/repos/{owner_name}/{repo_name}/actions/runs/{Run_ids}/jobs

We hit the error when we try to pull a good amount of rows, but it doesn't happen when we pull just a few rows