Exciting announcement for GitHub Copilot users 💚

[Akash1134]

Important Announcement 🔈

We are pleased to inform you that the GitHub Copilot Metrics Power BI app is now live and available for use! This robust tool provides valuable insights into your GitHub Copilot usage, enabling you to monitor license assignments and track daily usage trends across your GitHub organizations. It supports various Copilot integrations, including code completion in the IDE, chat functionality within the IDE, interactions in the GitHub.com UI, and summarizing pull requests.

Where can I access the dashboard?

You can download the app from AppSource and install it in your preferred Power BI workspace. For configuration, please refer to the provided setup instructions.

Which GitHub Copilot versions are supported?

The app supports GitHub Copilot Business and GitHub Copilot Enterprise. For more details see the REST API endpoints for GitHub Copilot usage metrics.

🤝 Please share your feedback in this community discussion. Thanks!

[leandromsft]

Hello @Akash1134 , I setup the App Configuration (Auth using PAT with full access), but I am getting the following error:

[ayodejiayodele]

Hi @leandromsft , it is likely due to the privacy level you have set. Change to another privacy level and try again.

[tpatil30]

Hi @Akash1134@ayodejiayodele ,

I have Power BI Desktop installed on my laptop but do not have access to the Power BI online service.
Can you please suggest how to download this Power BI report to my local machine and open it in Power BI Desktop?

[tpatil30]

Same here.

@ayodejiayodele After adding the app in the Power BI web, there is no option to download the .pbix file.

[ayodejiayodele]

1. In Power BI web, go to Apps and ensure you have at least version 16 installed
2. Then, go to Workspaces and open the Workspace corresponding to the same name of the app
3. Open the report with the name product_github_copilot_dev_metrics
4. On the File menu of the report, you should see Download this file. This is the .pbix file that you can customise with Power BI Desktop

P.S. You can also customise directly online without needing to do it locally on the client. Just click Edit right on the report.

[DattaGawali]

Hello @ayodejiayodele ,
I have installed App - GitHub Copilot Metrics Version 19.
I can see the default report view, but I cannot download it from file menu and then download this file.
It is giving below error

"Activity ID: bf5cb0d0-66f7-4843-a2c7-fe5958ac258f
Request ID: 1e7f5008-1c2b-ea56-423f-97b3c9bc54d9
Correlation ID: 3e00c9c3-f35f-90fc-842e-28d85587b326
Status code: 404
Time: Thu Dec 12 2024 15:27:31 GMT+0530 (India Standard Time)
Service version: 13.0.24766.32
Client version: 2411.3.21980-train
Cluster URI: https://d2d2794a61cc482396908e288fd554cc-api.analysis.windows.net/"

• I can't edit the parameter like dormant user value is 90 days, there is no option to change it

Please help

[DattaGawali]

@ayodejiayodele
Please can you share .pibx report directly or guide us how to download.

[kpstar48]

yes it is

[massimogentilini]

Note that due to other pending issue (https://github.com/orgs/community/discussions/145783) this exciting new tool it much less exciting, considering is stuck with data that are up to date until November 24th and no later than that...

[ayodejiayodele]

@massimogentilini I see this is partly resolved now. So, this is likely temporary. Don't let it ruin the excitement 😃

[massimogentilini]

yes it is!

[kpstar48]

yes it is

[ayodejiayodele]

The dashboard has some configurations including incremental refresh, which allows you to have up to 1-year usage trend of Copilot. 🚀 This feature is only compatible with Power BI Premium, Premium per user, Power BI Pro, and Power BI Embedded models.

[Venkatesh-Krishnan-R]

Hi, I attempted to access my enterprise account, but I noticed that the naming conventions for my organization and enterprise differ.
For the enterprise, I have a space (e.g., Abcd Efgh), while for the organization, I use a hyphen (e.g., Abcd-Efgh). Unfortunately, I'm having trouble connecting via the API with my GitHub username, and the dashboard refresh is not occurring. Can someone please help me?

[ayodejiayodele]

@Venkatesh-Krishnan-R Typically, an enterprise slug does not have spaces. It should be the single word that follows https://github.com/enterprises/ in the URL. Read more here

[arm-dkm]

I'm getting errors refreshing the data, whether I specify "null" (for all Organizations) or an individual specific Organization in the list, and regardless of what option I choose for privacy level...

Data source errorColumn 'organization' in Table 'CopilotOrgStats' contains a duplicate value 'xxxxxxxxxx' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

NOTE: Organization name has been redacted and replaced by "xxxxxxxxxx"

Any idea on what could be incorrect, or where else to look to diagnose?

[ayodejiayodele]

Hey @arm-dkm 👋

Version 19 is now out and fixes that duplicate value error you were getting. Could you give this a go and see? Let's know if this works

[davelacy]

This is the error I was getting too so disregard. Thanks @ayodejiayodele

[arm-dkm]

Yes, this has addressed my issues. Thanks

[Clas-Thurban]

Hej!
Today the refresh failed due to "duplicate" data received from the API, what is the bets way to remedy this error?
Data source error: Column 'usage_records.date' in Table 'CopilotEnterpriseUsageNewSchema' contains a duplicate value '1/13/2025' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

[tpatil30]

I am also facing this issue.

[ayodejiayodele]

Great question. We just fixed this in a newer version of the app over the weekend. Power BI introduced some auto-detected relationships to the model by accident. You can update to the latest release and I believe this would be fixed already.

[Clas-Thurban]

Thanks, yes, refresh now works fine again!

[alokbcg]

Hello, I was trying to set this up for GitHub EMU account but i keep getting this error:

The credentials provided for the Web source are invalid. (Source at https://api.github.com/orgs/*****/copilot/metrics.). The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.

I have used my GitHub EMU username and PAT token with required access for setting the board up. Also I have tried both Private and Organization Privacy level but i keep getting the above error. Any idea what I am doing wrong here?

[alokbcg]

@ayodejiayodele Its public only and I am using my GitHub Handle.

[ayodejiayodele]

I will recommend you try to consume the 5 APIs mentioned with the same token first. You can use curl in the terminal, or Postman, Insomnia or something similar. If you are successful with all 5, then the dashboard should work

[alokbcg]

@ayodejiayodele Appreciate all your support. All API endpoints work fine but the error still remains.

[lujmo11]

@alokbcg Did you ever get this fixed ? I have the same issue. I had it working but it stopped some weeks ago.
i tried the curl test on all apis with the PAT and it works fine.
I noticed that when go to semantic model > settings > data source > credentials I can see it has changed my username to the email address and is not using the github username . could that be the problem or does it ignore that anyway and just use the PAT ?

[lujmo11]

I just got it to work with a workaround. as I said the credtials entered in semantic model > settings > data source > credentials are not being saved .. I change them to use new PAT and apply .. then go back to and the old credentials are back again.
So instead I set up a "Gateway and cloud connections" > create a connection . I set up a my github username and new PAT and use that and the connection works and the sematic data refreshes correctly. Hope this helps .

[alokbcg]

@ayodejiayodele Request to share your inputs on the issue above

[ITDevOpsAdmins]

Hi everyone,

we would like to use the PowerBI report, but we only have an Organisation on GitHub, not an Enterprise.

What should we add to the Enterprise Slug if we don't have one?

Alternative URL

Would appreciate any assistance, as we need to report on the ROI. If successful we can purchase additional licenses to roll out to the rest of the development department, so would love to get this working.

Thank you in advance!

[ayodejiayodele]

This dashboard is only available for GitHub Enterprise instances

[ITDevOpsAdmins]

Thank you @ayodejiayodele

Is there perhaps an alternative available for GitHub organizations? The API available works only for the last 30 days I believe.

[ayodejiayodele]

You can clone this version on the repo and see if you can customise it

[SebLz]

Hello,

I am an admin of two GitHub Enterprise instances. One of them is a GitHub Enterprise Managed User (GHEMU) instance. While running the Power BI Copilot Metrics report, I encountered an issue where it fails to fetch data for the GHEMU instance, while it works fine for the other one.

Error Message:

When attempting to refresh the report for GHEMU, I get the following error:

Erreur de source de données:{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"The column 'Column1' of the table wasn't found."}}],"exceptionCulprit":1}}} URI du cluster: WABI-NORTH-EUROPE-E-PRIMARY-redirect.analysis.windows.net ID d'activité: 90447611-0716-4c65-a026-89949bdfc8c5 ID de demande: a3df2611-dadb-d40b-8050-38d511686c76 Heure: 2025-02-24 13:23:57Z 

Additional Information:

• Open-source solutions like [copilot-metrics-viewer](https://github.com/github-copilot-resources/copilot-metrics-viewer) work fine for both instances, so I doubt this is a permission or configuration issue.
• The report was obtained from the Power BI AppSource:
  • [GitHub Copilot Metrics on AppSource](https://appsource.microsoft.com/en-ie/product/power-bi/github.github-copilot-metrics?tab=Overview)
  • Installed via "Get it now" and used within [Power BI Online](https://app.powerbi.com/)

Export Issue:

Additionally, I am unable to export the .pbix file for either organization. The export fails with the following error:

ID d'activité: 90447611-0716-4c65-a026-89949bdfc8c5 ID de demande: dd3046f3-7dfb-5d1d-aad4-8eb227f7d1e5 ID de corrélation: 4903a676-ff7b-88d6-4c8a-23a9f22ef916 Code d'état: 404 Heure: Mon Feb 24 2025 14:36:04 GMT+0100 (heure normale d’Europe centrale) Version du service: 13.0.25310.47 Version du client: 2502.2.22869-train URI du cluster: https://wabi-north-europe-e-primary-redirect.analysis.windows.net/ 

Question for @ayodejiayodele :

You previously mentioned [github-developer-metrics](https://github.com/ayodejiayodele/github-developer-metrics), but it seems to be different from the Power BI Copilot Metrics report provided in the Power BI App.

Is there any place where we can find an editable version of the Copilot Metrics report?

Thanks!

[ayodejiayodele]

Thanks @SebLz , did you check the src directory? You should find a PBIP project. It's the exact copy of the app.

The error message seems to be pointing at the parameters supplied. Did you leave the OrganizationList as null string?

[SebLz]

Thanks @SebLz , did you check the src directory? You should find a PBIP project. It's the exact copy of the app.

The error message seems to be pointing at the parameters supplied. Did you leave the OrganizationList as null string?

Thanks for your reply, indeed the pbip in the src looks the same, I overlooked it!
Using that one, I was able to make the report work. The app still throws an error, even though the parameters are identical.
I tried with OrganizationList as an empty string and containing 1 and 2 orgs: same error each time.
Nevertheless, it's not a problem anymore as I'm now using the pbip file from the github repo which allows me to customize the report to my needs.

[aaron-seitz]

Thanks @SebLz , did you check the src directory? You should find a PBIP project. It's the exact copy of the app.

The error message seems to be pointing at the parameters supplied. Did you leave the OrganizationList as null string?

I am receiving the same error ("Data source errorExpression.Error: The column 'Column1' of the table wasn't found.. Column1. . The exception was raised by the IDbCommand interface."). Previously this had been working. I have tried it both with our org defined, as well as with it empty, and both fail the same.

This seems to be happening with the new app version.

[arunpa2023ai]

Thanks @SebLz , did you check the src directory? You should find a PBIP project. It's the exact copy of the app.

The error message seems to be pointing at the parameters supplied. Did you leave the OrganizationList as null string?

@ayodejiayodele I have downloaded the "github_copilot_dev_metrics " PBIP file. While opening I am not seeing the Visuals and report pages like in git hub copilot app in power BI service. How to add the pages and visual to this file ?

[aaron-seitz]

Hello - I was wondering when the capability to filter down to data at the Team level is going to be added?

There are endpoints that already exist for returning data narrowed down in this way, and following GitHub's suggestion we are utilizing a single org to manage Copilot access, meaning there is currently no way to filtering down to a more granular view of the data.

[JCGreaves]

I'd love to see this as well as we are struggling to understand where the engagement is across out teams being able to get team level information would really help if focus in on what make a teams use a success. Without this sort of insight we are struggling to justify the cost for some area's

[ayodejiayodele]

Hi @JCGreaves , @aaron-seitz

There's a video on how you can customize and add team-level metrics

[aaron-seitz]

Hey @ayodejiayodele, the video is appreciated, however it looks like it is using PowerBI Desktop - is there a method for doing this that will work on Macs?

[ayodejiayodele]

I'm afraid Power BI Desktop is only available in Windows. Alternatively, you can open the .pbip in your favourite IDE and edit the JSON

[runningtiger21]

We have the GitHub Copilot Metrics Power BI app setup in our Power Bi workspace. It is not longer able to pull the data from the Copilot API. Has there been an outage or an update to the app for the new API endpoints? We setting up the app we followed these instructions and everything worked great until 2/26 when the data didn't refresh. We aren't able to change the endpoints the app is hitting. We can only enter in User and Organizations credentials.

[ugurakineren]

Hi, I guess the problem still persists. We are still getting error related with credentials. "The credentials provided for the Web source are invalid. (Source at https://api.github.com/orgs/Dogus-Teknoloji/copilot/metrics" . Does someone know about status of the bug?

[stebje]

Hi @ugurakineren that sounds like your PAT not having the correct permissions and/or scope. Please make sure to cross-check your PAT against the permissions/scopes listed in the instructions.

In your case - using the url you provided - you can do a quick sanity check by;

curl -L \ -H "Accept: application/vnd.github+json" \ -H "Authorization: Bearer <YOUR-PAT-TOKEN>" \ -H "X-GitHub-Api-Version: 2022-11-28" \ https://api.github.com/orgs/Dogus-Teknoloji/copilot/metrics 

... and validate that you get a response.

[SertayKabuk]

Hi @stebje,
Instructions says we need to create a classic token. But when try to use that token (token created with full permissions) with powerbi app, it calls this endpoint for all the organizations in the enterprise:

https://api.github.com/orgs/Dogus-Teknoloji/copilot/metrics

This endpoint does not accept classic tokens. It says:

{
"message": "Dogus-Teknoloji forbids access via a personal access token (classic). Please use a GitHub App, OAuth App, or a personal access token with fine-grained permissions.",
"documentation_url": "https://docs.github.com/rest/copilot/copilot-metrics#get-copilot-metrics-for-an-organization",
"status": "403"
}

Basically , one api need classical token (https://api.github.com/enterprises/dogus-holding/copilot/metrics, this works fine)
other one needs fine grained token.

I can not find a way to create fine grained token for enterprise. How can we do that?

[SertayKabuk]

I've found the issue, we needed to allow access for classical tokens for each organization in our enterprise.
Thanks, it's working now.

[stebje]

Indeed @SertayKabuk there is a policy for restricting access to enterprise resources by token type. Glad to hear you sorted it out 👍

[joslat]

Hi,
I am admin in a GitHub Organization, "orga-X" which is part of the enterprise "enterprise-X" - I am not part of it.
I create classic PAT with all the permissions needed and enabled it without trouble, which has admin:enterprise as somebody suggested on this thread, instead of manage_billing:enterprise and read:enterprise. (I tried with them too)

(the token is also authorized)

I configure everything properly

With my github user name, the PAT, Auth set to Basic and privacy to Public.

If I only want to get the metrics from this organization, I only need owner to the organization not? or I need to be owner on the Enterprise account as well? I think I may be responding to myself, but can somebody confirm this?

[joslat]

I think this is the case:

Is there any way to request only the metrics for a single organization? or I definitely need enterprise permissions?

[stebje]

Hi @joslat - some of the data tables in the dashboard require enterprise-level read access as listed in the instructions so unfortunately you do need to have either the Billing manager role or the Enterprise owner role.

[joslat]

@stebje - thanks, that was definitely it! 👍

[geethasri-rev]

Hi,

I am getting this error which was working fine before -

Data source error: | DataSource.Error: Web.Contents failed to get contents from 'https://api.github.com/enterprises/mmm/copilot/usage' (404): Not Found. Microsoft.Data.Mashup.ErrorCode = 19006. DataSourceKind = Web. DataSourcePath = https://api.github.com/enterprises/mmm/copilot/usage. Url = https://api.github.com/enterprises/mmm/copilot/usage. . The exception was raised by the IDbCommand interface. -- | -- Cluster URI: | WABI-US-NORTH-CENTRAL-G-PRIMARY-redirect.analysis.windows.net Activity ID: | b2847924-e629-b882-ae4d-378a83722b78 Request ID: | 7fefb166-41ce-0281-d153-3b52658fad18

[geethasri-rev]

Hi,

I am getting this error which was working fine before -

Data source error: | DataSource.Error: Web.Contents failed to get contents from 'https://api.github.com/enterprises/mmm/copilot/usage' (404): Not Found. Microsoft.Data.Mashup.ErrorCode = 19006. DataSourceKind = Web. DataSourcePath = https://api.github.com/enterprises/mmm/copilot/usage. Url = https://api.github.com/enterprises/mmm/copilot/usage. . The exception was raised by the IDbCommand interface. -- | -- Cluster URI: | WABI-US-NORTH-CENTRAL-G-PRIMARY-redirect.analysis.windows.net Activity ID: | b2847924-e629-b882-ae4d-378a83722b78 Request ID: | 7fefb166-41ce-0281-d153-3b52658fad18

Any update on this issue please?

[psdarwin]

I am using a credential that has been working and has not changed, but I started getting auth errors. I have verified the permissions and regenerated the token. I have verified the GitHub PAT has access using an API call to https://api.github.com/user. I have even tried reinstalling the PowerBI app. I continue getting auth errors.

Here is the current error I am seeing.

Data source error:{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"The credentials provided for the Web source are invalid. (Source at https://api.github.com/enterprises/my-enterprise/copilot/metrics.)"}}],"exceptionCulprit":1}}} Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net Activity ID: 0d9f7b43-3a9c-4094-bdb9-1917c1a3d0fd Request ID: 20875f4c-99cb-f613-dd44-cac33982fccc Time: 2025-04-01 20:57:12Z 

Any advice would be appreciated.

[psdarwin]

I found the issue - the account that is used to generate the PAT has to have enterprise level permissions. It appears when I thought I had it working, it was using the last successful sync of data from when it was configured with my personal PAT. The service account I was trying to use did not have that level of permission, so it failed. Kind of scary to require such high level permissions for a report, but that was the issue.

I ended up using my personal PAT, not sharing the workspace, and subscribing people to the report.

[thaiknguyen]

It does not seem like the organization filter works for most of the pages. We have 2 orgs in the enterprise that has copilot licenses. Filtering on one of the orgs does not update any of the reports on the page. Oddly, it does work only on the "Org Usage Metrics" page.. how can this be fixed?

Also, i'm a bit new to Power BI. is there a way to get the PBIX file? We added this app into our own, but unable to share it to others without a license. The reports we created ourselves can be shared, but not this app.

[jboulware]

We have been running this PowerBI app for about a month. We're running the most recent version of it and it has been running fine for that time. However, yesterday, the refresh began failing:

DataSource.Error: Web.Contents failed to get contents from 'https://api.github.com/enterprises/hearst/settings/billing/advanced-security' (422): Unprocessable Entity.
Microsoft.Data.Mashup.ErrorCode = 10117
DataSourceKind = Web.
DataSourcePath = https://api.github.com/enterprises/hearst/settings/billing/advanced-security
Url = https://api.github.com/enterprises/hearst/settings/billing/advanced-security
The exception was raised by the IDbCommand interface.

We didn't change anything in our environment. However, it seems that the issue is that the "advanced_security" API endpoint now requires a query parameter for "advanced_security_product" which this app doesn't provide. I tested in postman and it also returns a 422 if I don't send a value for that parameter.

_**"message": "You must specify 'advanced_security_product' in this request.", "documentation_url": "https://docs.github.com/rest/enterprise-admin/billing#get-github-advanced-security-active-committers-for-an-enterprise", "status": "422"**_ 

If I do send a value of code_security or secret_protection, it is successful (200 OK). I assume that the owner needs to update this app for this to be fixed... or is there some workaround for me to fix it?

[ayodejiayodele]

Hi all, this has now been fixed. You're all right. It was due to a change in the API's required query parameters. It has now been updated in the source file. PR is underway and a new version should be published in the AppSource in the coming days. Thanks all 🚀

[jboulware]

Thank you! Github seems to like to change their API endpoints and query parameters fairly often. Any chance that a future version of this app might incorporate some updates to allow data to still flow in if an endpoint or query parameter is incorrect?

Or even allow the PBIX to be downloaded so that we can modify it ourselves for things like this in the future?

[JoshuaMillerNebraskablue]

Hi all, this has now been fixed. You're all right. It was due to a change in the API's required query parameters. It has now been updated in the source file. PR is underway and a new version should be published in the AppSource in the coming days. Thanks all 🚀

Good morning @ayodejiayodele
I apologize for my ignorance on what data "should" be pulled back. I saw on the PR it's only adding 1 security product. Should this include both per the documentation?

/settings/billing/advanced-security?advanced_security_product=code_security&advanced_security_product=secret_protection

[BrollyAI12]

It seems like the issue is related to the advanced_security API endpoint now requiring an additional query parameter (advanced_security_product) that was previously not needed. I tested this with Postman and received a 422 Unprocessable Entity error when the parameter was omitted. The solution would be to modify your PowerBI app to include this new required parameter when making the API call to avoid the 422 error.Hope this helps!
MLOPS Training in Hyderabad

[matt-buchanan]

Hi all, this has now been fixed. You're all right. It was due to a change in the API's required query parameters. It has now been updated in the source file. PR is underway and a new version should be published in the AppSource in the coming days. Thanks all 🚀

Just to flag up my comment below - the fix for this has broken the dashboard for people who aren't using the unbundled Advanced Security offering.

[jboulware]

@ayodejiayodele - Thank you for the fix on v26 of this PowerBI app. Seems to work now.

I did want to address two other questions that I know others have as well:

1. When a new version is released, any historical metrics beyond the 30 day mark are lost. How can the older data be preserved when a new version of the app is installed?
2. Can you make the PBIX file downloadable/editable so that we can edit our own dashboard?

Thanks!

[ayodejiayodele]

Hey @jboulware,

Glad that this has been fixed for you 😎

When a new version is released, any historical metrics beyond the 30 day mark are lost. How can the older data be preserved when a new version of the app is installed?

Typically, you shouldn't lose historical data if you choose the option to upgrade, unless in cases where the updated version is not backwards-compatible. You should be fine from here on out.

Can you make the PBIX file downloadable/editable so that we can edit our own dashboard?

Yes you can customise the dashboard, but this would be PBIP, not PBIX and is compatible with most versions of Power BI Desktop. Feel free to clone this repo and open the /src directory. It is important that you use the *.pbip file.

[ayodejiayodele]

Hi all, if you wish to customise the dashboard, you can clone this repo and open the /src/github_copilot_dev_metrics.pbipPBIP file in Power BI Desktop.

[OzRAGEHarm]

❤️

[matt-buchanan]

So I think a recent fix around the advanced-security APIs has broken this dashboard for me. I have been getting the error message below since I last updated. Just for context - although I suspect most customers will have gone onto the new advanced security offering at the start of last month, there will be enterprise customers like me who are going to be stuck on the old offering until our contracts are renewed - this is over a year away for me unfortunately. Unfortunately the API implementation is not particularly helpful - if you run this query with the advanced_security_product parameter set to anything, it will fail with an HTTP 422 error.

Is it possible to update the dashboard so it will support the old advanced security product alongside the new one please?

Data source error: DataSource.Error: Web.Contents failed to get contents from 'https://api.github.com/enterprises/redacted/settings/billing/advanced-security?advanced_security_product=code_security' (422): Unprocessable Entity. Microsoft.Data.Mashup.ErrorCode = 10117. DataSourceKind = Web. DataSourcePath = https://api.github.com/enterprises/redacted/settings/billing/advanced-security. Url = https://api.github.com/enterprises/redacted/settings/billing/advanced-security?advanced_security_product=code_security. . The exception was raised by the IDbCommand interface.

[matt-buchanan]

Just to add to this - I've also raised the 422 API response via support - imo it should fail more gracefully than that, it shouldn't be on the API consumer to have to figure out internal platform details like this.

[matt-buchanan]

Hi @ayodejiayodele - just bumping this for your attention, is there any possibility of a fix for us enterprise customers on this?

[ayodejiayodele]

Hey @matt-buchanan Great news!

A new version has been released with a fix that accommodates various options. If you update to the latest version (version 27), you will find an additional parameter named, GHASStandalone. In your case update the parameter as False if you don't have standalone GitHub Advanced Security. Set it to True if you do.

I also prepared a short video walkthrough to help with this. Let me know if it helps.

[matt-buchanan]

Ah, that's perfect, thank you - just installed now and its working a treat :)

[ayodejiayodele]

That's fantastic. Glad it helped! 🎉

[SteelBlueVision]

The most exciting announcement for Github Copilot Pro/Pro+ users is actually:

May 8 has been moved to June 4 and you all know exactly what May 8 signified previously for Copilot Pro and Pro+ users:
🌬️💸💳 ⟹ 💲💲💲 ⟹ 😞

Someone at MS probably realized that having Copilot metered usage kick in right in the middle of the Microsoft 365 Community Conference is probably not the smartest marketing move, from a community optics perspective.

[thaiknguyen]

@ayodejiayodele
As the Copilot Metrics API now returns information about the models used, are there any updates to have this information in the Power BI app?

[ayodejiayodele]

Thanks @thaiknguyen. It all depends on the API.

The API currently displays whether it's a custom model or default model, but not which specific model.

Once the information you need is available in the API, you can report on it from Power BI.

[aaron-seitz]

Hello, I had a question GH Support wanted me to ask. Which API endpoint is being used to source the data used for the Seat Activation table in the report, which indicates each user's last activity?

We have seen some discrepancies between the data presented in the dashboard and actual user experience, where it was indicated a user was inactive for 11 days however they had been using it during that time period.

[ayodejiayodele]

Hi @aaron-seitz ,

Here is a list of the API endpoints being used by the dashboard. You can curl them directly and you should get the same result. For user's last activity, that would be the API to list all seat assignments at the enterprise level. Hope this helps.

Thanks

[aaron-seitz]

Thanks!

[shreeinamdar]

Hello,
I'm new to Power-BI. I was able to follow the instructions and connect to my enterprise account. The app/model/reports are showing data. However, I'm seeing data for all enterprise users even if I have configured my specific Org on connection screen and the API end point is still pointing to generic https://api.gihub.com. If I change it to https://api.gihub.com/orgs/<MY_ORG> its showing an error. I tried to download the pbix file, but it says since the data was refreshed, it cannot download it. What am I not doing right? I only want to see the metrics for my Org.

[shreeinamdar]

Just to also add, I'm both an Enterprise Admin and Org Admin, the PAT has been created per the instructions

[RGCo30]

Hello, I am new to the Copilot , I am trying to install GitHub Copilot Metrics for power BI. I am following this article https://appsource.microsoft.com/en-us/product/power-bi/github.github-copilot-metrics but no luck , I am getting error " Can't Install App", Installing template apps has been disabled for you. Please contact your administrator".
I have two questions:

1. I have Power BI Report server May 2024 version on prem. GitHub Copilot Metrics for power BI will work on Onprem version.
2. Any special permissions needed to install GitHub Copilot Metrics for power BI from Microsoft AppSource

[RGCo30]

Hello, Can someone respond to my enquiry and share your knowledge. thanks

[ayodejiayodele]

Hi @RGCo30, the app is only compatible with Power BI online service or the Power BI Desktop

[RGCo30]

Hello, Thank you for responding to my question. Can you please direct me to the instruction on how to setup install GitHub Copilot Metrics for power BI Desktop since we are on Power BI on prem. Documentation on this forum is referring online services. Thank you in advance.

[stebje]

Hi @RGCo30 - as far as I know there's no way to "port" an AppSource listing into PBI Report Server directly.

What you can do is to either;

1. Use an alternative dashboard tempalte e.g. this one and import one of the .pbix files in the /samples directory
2. Open https://appsource.microsoft.com/en-us/product/power-bi/github.github-copilot-metrics in PBI Desktop and export a pbix file, which you can then import into your on-prem PBI instance

[mgbharathkumar]

Hi All.

We have setup GitHub Copilot Metrics powerBI dashboard using Appsource "https://appsource.microsoft.com/en-us/product/power-bi/github.github-copilot-metrics?tab=overview".

Post that, we did a configuration by following the guide "https://gist.github.com/ayodejiayodele/3115d60ce7420891d2f005f7395ce99c". Credentials and token was successfully authenticated. During the refresh we are getting below error, please help to guide what is further missing in setup or is it a product issue?

Thank you in advance.

[jam0220]

I'm running into the same issue. Did it resolve for you?

[mgbharathkumar]

No, still facing the same issue. I have tried many other ways but no luck.

[hock37wong]

Hi @Akash1134

 I tried to connect GitHub Copilot Metrics in Power BI (web version), however, I am getting the error below. Could you please help me with it? Thanks 

Regards
Hock Lin

[jam0220]

I'm running into the same issue. Did it resolve for you?