gopalv's avatar
gopalv
Microsoft Employee
6 years ago
Status:
New

Power BI Github Not Computing Issue Total Correctly

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 tell...
Dashboards
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
6 years ago

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

Completed Ideas