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

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
Uday3th1rr
Frequent Visitor

Rest API

Can we create Custom Column and Parameter through API and push it into power bi Workspace??

 

I am Pushing Data through API by creating Tables and Measures, I Also need to create custom Column and Parameter in this API? can sombody pls help??

 

API : 

Push Datasets - Datasets PostDatasetInGroup

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets

1 REPLY 1
ichavarria
Solution Specialist
Solution Specialist

Hi @Uday3th1rr,

 

Yes, you can create custom columns and parameters in Power BI through its API. Here are the steps to follow:

 

  1. Create a dataset using the API endpoint you mentioned, i.e., POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets.

  2. Once the dataset is created, you can create a table in it using the POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/tables API endpoint.

  3. After creating a table, you can add a custom column to it using the POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/tables/{tableId}/columns API endpoint. Provide the column name, formula, data type, and any other relevant information in the request body.

  4. Similarly, you can create a parameter using the POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/parameters API endpoint. Provide the parameter name, data type, and default value in the request body.

  5. Finally, push the data into the dataset by creating measures or adding rows to the table.

 

Note that you need to have the necessary permissions and authentication to create custom columns and parameters in Power BI through its API.

 

 

Best regards, 

Isaac Chavarria

If this post helps, then please consider Accepting it as the solution and giving Kudos 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.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors