Exciting announcement for GitHub Copilot users 💚 #145645
Replies: 24 comments 70 replies
-
Hello @Akash1134 , I setup the App Configuration (Auth using PAT with full access), but I am getting the following error: |
Beta Was this translation helpful? Give feedback.
-
Hi @Akash1134 @ayodejiayodele , I have Power BI Desktop installed on my laptop but do not have access to the Power BI online service. |
Beta Was this translation helpful? Give feedback.
-
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... |
Beta Was this translation helpful? Give feedback.
-
The dashboard has some configurations including incremental refresh, which allows you to have up to |
Beta Was this translation helpful? Give feedback.
-
Hi, I attempted to access my enterprise account, but I noticed that the naming conventions for my organization and enterprise differ. |
Beta Was this translation helpful? Give feedback.
-
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? |
Beta Was this translation helpful? Give feedback.
-
Hej! |
Beta Was this translation helpful? Give feedback.
-
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? |
Beta Was this translation helpful? Give feedback.
-
@ayodejiayodele Request to share your inputs on the issue above |
Beta Was this translation helpful? Give feedback.
-
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? 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! |
Beta Was this translation helpful? Give feedback.
-
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:
Additional Information:
Export Issue:Additionally, I am unable to export the
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! |
Beta Was this translation helpful? Give feedback.
-
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. |
Beta Was this translation helpful? Give feedback.
-
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. |
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
-
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 |
Beta Was this translation helpful? Give feedback.
-
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.
Any advice would be appreciated. |
Beta Was this translation helpful? Give feedback.
-
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. |
Beta Was this translation helpful? Give feedback.
-
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. 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.
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? |
Beta Was this translation helpful? Give feedback.
-
@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:
Thanks! |
Beta Was this translation helpful? Give feedback.
-
Hi all, if you wish to customise the dashboard, you can clone this repo and open the |
Beta Was this translation helpful? Give feedback.
-
❤️ |
Beta Was this translation helpful? Give feedback.
-
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?
|
Beta Was this translation helpful? Give feedback.
-
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. |
Beta Was this translation helpful? Give feedback.
-
@ayodejiayodele |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
-
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!
Beta Was this translation helpful? Give feedback.
All reactions