Power BI Github Not Computing Issue Total Correctly

[gopalv]

I am trying to use the default dashboard for showing the change in total open issues over time in my repo. Unfortunately, this number is being computed incorrectly. Power BI says 704, but GitHub tells me it is 523. https://github.com/dotnet/machinelearning/issues?q=is%3Aissue+is%3Aopen

[v-qiuyu-msft]

Hi @gopalv, 

Based on my test in Power BI desktop version 2.76.5678.782 64-bit (December 2019), use below Power Query to get data from Github and filter the open issues: 

let
    Source = Github.Tables("dotnet", "machinelearning"),
    issues = Source{[Key="issues"]}[Data],
    #"Filtered Rows" = Table.SelectRows(issues, each ([state] = "open"))
in
    #"Filtered Rows"

After loading the data to data model, we can see there are 523 open issues. Please try the same Power Query in the same Power BI desktop as ours then test again. 

Best Regards,
Qiuyun Yu

[gopalv]

Hi Qiuyun,

Thanks for your response. You are correct that this number displays correctly in the Desktop version. However, I now have a different problem. I would like to be able to filter issues by the label that was applied to them, but this table doesn't seem to include labels, whereas the GitHub integration in the web version of Power BI does.

Any idea how to get information on labels?

issues with labels

[v-qiuyu-msft]

Hi @gopalv, 

You can download the sample Github pbix file here. Then open it in Power BI desktop, go to Query Editor, find the Issues query table, you can see its Power Query. 

Best Regards,
Qiuyun Yu