SonarQube to Power BI

SonarQube Server / Community Build
1

We are using sonarqube.laerdal.com/ .
Is it possible so stream the data from SonarQube to Power BI ( https://powerbi.microsoft.com/en-us/ ).
Have tried to find other who have tried this, and also looked in the API for SonarQube.

3

Hello @paasland,

Welcome to the SonarSource community :wave:. We hope you’ll enjoy it.
The only way to extract data out of SonarQube to store elsewhere is the Web API. This is more a pull mechanism than streaming, just to be clear.
I don’t know what data you want to extract (typically this is projects metrics) and for what purpose ? Just be careful to not pull as much data as you can from SonarQube, just because it’s possible.
Extracting data is usually for reporting purpose. Although this is can be needed, SonarQube primary objective is to act on quality problems (in a nutshell, it’s ok to report on quality, it’s better to fix quality problems), and most of the data is most actionable from within SonarQube.

Olivier

5

Hi @OlivierK I also need assistance over integration of SonarQube results to PowerBI. Can you help me with the API it works with now. I just need the repo is being scanned by SonarQube. So on PowerBI it will show a ‘Yes’ or ‘No’ response.

6

Hello @Abomination,

Welcome to the Sonar community.
As a best practice, when a thread is 2 years old, it’s better to open a new one than to add posts on the old one, especially if the topic is not exactly the same.

Regarding your need,

  • api/components/search?qualifiers=TRK will list all projects. Beware that this API is paginated. If you have many projects, all of them may not be returned on the first page. You have to iterate on pages. The default page size is 100 (projects), the max size can be specified as 500 (Pass ps=500 in your request)
  • api/components/show?component=<projectKey>

will give you details of a given project and in particular the last analysis date.