Forum Discussion

Uday3th1rr's avatar
Uday3th1rr
Frequent Visitor
3 years ago

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 ...
Need Help
Tips and Tricks
Tutorial Requests
ichavarria's avatar
ichavarria
Solution Specialist
3 years ago

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