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
5 years ago

Hi,

I don't know if I understood your request correctly with "convert custom function steps to common query table steps", but I have transformed my request like this :

let
    BaseUrl = "https://sonar.xxx.xxx",
    RelPath = "api/projects/search",
    EntitiesPerPage = 500,

    GetJson = (Url) =>
        let options = [RelativePath=RelPath, Headers =[#"Content-type"="application/json"]], // pour la Basic en Base64 : token + ":"
            RawData = Web.Contents(Url, options),
            Json    = Json.Document(RawData)
        in  Json,

    Url   = BaseUrl,
    Json  = GetJson(Url),
    components = Json[components],
    #"TableConvert" = Table.FromList(components, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
    #"TableConvert"

 

The problem is always the same with referesh.

I suspect the problem is with the SonarQube API. Has anyone used it in PowerBI before? Does the automatic refresh work?

 

Thanks

Yves

Anonymous's avatar
Anonymous
Not applicable
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!