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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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