Power BI Github Not Computing Issue Total Correctly

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

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

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