Forum Discussion
Solved
Expand column generate bad api url
Hello, as I am pretty new with api calls in PowerBi i cant resolve this issue with bad url call. I have column of table type which i want to expand as standard but it generates bad url for my api. ...
- 29-04-2025 12:41 PM
At the end i made it work by not using odata feed source but i imported it as Web contents from URL, and in the API url i defined expand property.
luptakd
i would do this simplae way.
let
Source = YourTable,
AddURL = Table.AddColumn(Source, "CorrectURL", each "https://yourapi.com/RestApi/v1/Objects/" & Text.From([ID]) & "/properties")
in
AddURL
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
This gave me a nested url and recursive error.