Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
luptakd
Frequent Visitor

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.

luptakd_0-1745499944355.png

 

luptakd_1-1745500029232.png

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.

 

 

 

1 ACCEPTED SOLUTION
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.

 

luptakd_0-1745923360066.png

 

 

View solution in original post

6 REPLIES 6
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.

 

luptakd_0-1745923360066.png

 

 

v-shamiliv
Community Support
Community Support

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
Super User
Super 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
AddURL

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!



This gave me a nested url and recursive error.

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_1-1745562094684.png

 

 

lbendlin
Super User
Super 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?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.