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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Cookistador
Helper III
Helper III

How to pass post api in Power BI?

Hello everyone,n

 

I am a total newbie to this interface of power BI, at my company a rerst api is used with Tableau Web connector to retrieve some information from a website and then tableau sent back this data into the right format

 

As it is not possible to use this connector into Power Query, I am working on a POC, and I needed to build a post api, so this is the information I have from my services, in tableau the user can modified a few parameters

 

This is the webservice I have to use: https://mywebsite.com/api/queries (it is a POST)

 

The user can select some filter like data and country and add the parameters they would like to retrieve

Cookistador_1-1713879346107.png

 

For example this selection will return the following requerst payload:
[{query: "stack(ts2mat(3,"2000","2022"), "country", ["AT"])", env: {freq: "A"}}]

 

I tried to follow the following guide, but I'm not able to achieve this, I think I'm doing something wrong with my request payload

 

Any steps to achieve this step?

 

Many thanks in advance for your help

 

 

 

 

1 ACCEPTED SOLUTION
v-jialongy-msft
Community Support
Community Support

Hi @Cookistador 

 

Hope the following documents will help you solve your problem:

Using the POST Method with REST APIs Inside Power BI - Data with Dom

Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn

 

 

 

 

Best Regards,

Jayleny

 

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

View solution in original post

1 REPLY 1
v-jialongy-msft
Community Support
Community Support

Hi @Cookistador 

 

Hope the following documents will help you solve your problem:

Using the POST Method with REST APIs Inside Power BI - Data with Dom

Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn

 

 

 

 

Best Regards,

Jayleny

 

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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