Forum Discussion
Unable to create dataflow due to referencing a dynamic data source
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]] ) )
Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1
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]]
)
)