Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

sonarQube API dynamic data

Hi, I want to access Sonar data via the API with the following request : let BaseUrl = "https://sonar.xxxx.xxx", RelPath = "api/projects/search", EntitiesPerPage = 500, GetJson = ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Anonymous,

    I mean unpackage your custom functions, you can take a look at the following codes:

    let
    BaseUrl = "https://sonar.xxx.xxx",
    RelPath = "api/projects/search",
    EntitiesPerPage = 500,
    Json =
        Web.Contents(
            BaseUrl,
            [
                RelativePath = RelPath,
                Headers = [
                    #"Content-type" = "application/json"
                ]
            ]
        ),
    components = Json.Document(Json)[components],
    #"TableConvert" =
        Table.FromList(
            components,
            Splitter.SplitByNothing(),
            null,
            null,
            ExtraValues.Error
        )
in
    #"TableConvert"

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, 

I also tried to acces Sonar data via the API in Power BI, i received the same error : 

You can't schedule refresh for this dataset because the following data sources currently don't support refresh:

  • Data source for Query1

I managed to deal with it but when i deployed to the server and set an automatic refresh, i had to update the credentials in Power BI Service. In Power BI Desktop, I can use the Basic Auth and the Sonar Token in User name without password, but in Power BI Server, i am not allowed to leave the password field empty. Do you know how i can connect?

 

 

Thank you, Pauline.

Kajin's avatar
Kajin
New Member
1 year ago

I know this thread is quiet old, but did you get a solution for this when you faced it?

I am facing this now after 2 years of your query!