Forum Discussion

hjoshi4u26's avatar
hjoshi4u26
Regular Visitor
3 years ago
Solved

Dynamic Dataset refresh error

I have a list of Pull Request IDs from which I have to get the data via REST APIs. I am able to fetch the data locally, but when I publish it to PowerBI Service, I face the error "This dataset includ...
  • hjoshi4u26's avatar
    3 years ago

    No worries. I have done it. Sharing the steps below. Initially I was doing below steps to get REST API Output in Json Records:-->

    #"Pull Request API" = Table.AddColumn(#"Changed Type2", "Pull Request API", each "https://*************.com/******/_apis/git/pullrequests/"&[Pull Request Id]&"?api-version=7.0", Text.Type),
    #"Transformed to Binary" = Table.TransformColumns(#"Pull Request API", {{"Pull Request API", VSTS.Contents}}),
    #"Transformed to Json" = Table.TransformColumns(#"Transformed to Binary", {{"Pull Request API", Json.Document}}),

    .

    But instead I did this:-->
    #"Pull Request API" = Table.AddColumn(#"Changed Type2", "Pull Request API",each
         Json.Document(
              VSTS.Contents(

                   "https://************.com/**********/_apis/git/pullrequests/",

                   [RelativePath = [Pull Request Id]&"?api-version=7.0"]

              )

         )
    ),

    .

    This solved my problem. I watched a youtube video which explains very easily how to do it, sharing the link below.

    https://youtu.be/sv_upbpq_Cw