Expand column generate bad api url

[luptakd]

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.

[luptakd · Accepted solution]

‎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.

[v-shamiliv]

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.

[johnbasha33]

@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 !!

[luptakd]

This gave me a nested url and recursive error.

[luptakd]

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

[lbendlin]

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?