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.

Top Solution Authors