Forum Discussion
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.
Correct url should be without brackets and separated with slash as standard http url not as shown with bracket:
Url=https:// ... RestApi/v1/Objects/81/properties
How can i adjust this syntax to generate the correct url?
Thanks.
- ā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.
6 Replies
- lbendlinSuper User
Technically Object(81) and Object/81 should do the same thing. Have you tried pre-expanding the object directly in the original OData API call?
- luptakdFrequent Visitor
I tried to call api with parameters that are aviable for expand as
... "/v1/objects?$expand=properties", null, [Implementation="2.0", MoreColumns=true])
i dont know if powerquerry sends the link as https link
https://...RestApi/v1/objects?$expand=properties
or as odata context
https://...RestApi/v1/$metadata#Objects(properties())
but i got an error that shows the odata context link which is not working
- johnbasha33Super User
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
AddURLDid I answer your question? Mark my post as a solution! Appreciate your Kudos !!
- luptakdFrequent Visitor
This gave me a nested url and recursive error.
- AnonymousNot applicable
Hi luptakd
Thank you for reaching out microsoft fabric community forum.I wanted to check if you had the opportunity to review the information provided by johnbasha33 . Please feel free to contact us if you have any further questions. If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you. - luptakdFrequent Visitorā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.