Forum Discussion

Rallmo's avatar
Rallmo
Helper I
1 year ago
Solved

Unable to create dataflow due to referencing a dynamic data source

Hi In my CMDB I have a table containing Application assets, these assets are linked to other things like servers, other applications and so on. With an API call I'm able to gather information abou...
Need Help
  • Rallmo's avatar
    Rallmo
    1 year ago

    I wasn't able to decipher how to use the documentation to solve my issue, but I found this YT video from BI Elite that was helpful in understanding how i could use RelativePath. Making sure your Power BI web data source refreshes online (RelativePath, Query, BrowserContents)
    I thought that I had to use Query as an input to use RelativePath and that's what I got stuck on.

     

    So for anyone experiencing similar issues, this is the bit of code that solved it for me. 

    Json.Document(
      Web.Contents(
          "https://www.topdesk.net/tas/api/",
          [RelativePath = "assetmgmt/assetLinks?sourceId="&[Id]]
        )
      )

     

Rallmo's avatar
Rallmo
Helper I
1 year ago

I wasn't able to decipher how to use the documentation to solve my issue, but I found this YT video from BI Elite that was helpful in understanding how i could use RelativePath. Making sure your Power BI web data source refreshes online (RelativePath, Query, BrowserContents)
I thought that I had to use Query as an input to use RelativePath and that's what I got stuck on.

 

So for anyone experiencing similar issues, this is the bit of code that solved it for me. 

Json.Document(
      Web.Contents(
          "https://www.topdesk.net/tas/api/",
          [RelativePath = "assetmgmt/assetLinks?sourceId="&[Id]]
        )
      )

 

lbendlin's avatar
lbendlin
Super User
1 year ago

The recommended approach is to use the Query parameter for query values.  There are some corner cases where Power Query encodes the full URL wrongly, in those scenarios including the query values in the RelativePath is an acceptable option.

  • Rallmo's avatar
    Rallmo
    Helper I
    1 year ago

    Gotcha! 👍

    Thanks for your help.