Forum Discussion
Rallmo
1 year agoHelper I
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...
- 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
1 year agoSuper User
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
1 year agoHelper I
Gotcha! 👍
Thanks for your help.