Forum Discussion

luptakd's avatar
luptakd
Frequent Visitor
1 year ago
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.

 

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

  • 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?

  • luptakd's avatar
    luptakd
    Frequent 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

     

     

    • luptakd's avatar
      luptakd
      Frequent Visitor

      This gave me a nested url and recursive error.

  • Anonymous's avatar
    Anonymous
    Not 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.

  • luptakd's avatar
    luptakd
    Frequent 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.