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
kasife
Helper V
Helper V

API parameter

Hi all,

Can anyone guide me?
I'm trying to query an API, but I believe I'm not managing to structure the path correctly. 

 

Here are the requested parameters in the API:

kasife_1-1671570369944.png

 

kasife_0-1671570356180.png

 

In postman the records are being returned perfectly:

kasife_2-1671570582635.png

 

Query in Power BI

kasife_3-1671570860606.png

 

Result in power BI after invoking the function (Enterprise does not exist)

kasife_4-1671570963857.png

Can anyone help me if there is any detail missing in the parameter that I created in Power BI?

 

2 REPLIES 2
v-xiaotang
Community Support
Community Support

Hi @kasife 

Thanks for reaching out to us.

Here are 2 tutorials about how to use API in Power Query for your reference, 

Getting Started with API's in Power Query • My Online Training Hub

Call Rest APIs from Power BI / Power Query – Power Platform Training (powerplatformtrainings.com)

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

@v-xiaotang 

I was able to query records from other tables using the same code structure, but I'm not sure about this one in particular because of the details of the keys { idEmpreendimento } in the path. This small detail I would like to know what I could have done wrong.

kasife_0-1671716341824.png

 

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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.