Forum Discussion
How to create CG Measures , Date Dimension Table , Calculated Columns through Rest API .
Hi Anonymous,
Dax functions are based on the data model(AS instances), they weren't able to be used in the rest API.
Data Analysis Expressions (DAX) Reference - DAX | Microsoft Docs
For the calendar table, you need to manually create a data table with date values and different types of Dimension fields.
Reference link about generate calendar table based on C# language:
Generate Dimension Table in C# · GitHub
Regards,
Xiaoxin Sheng
Anonymous Thanks for your reply.
So it means we can't create a dynamic date dimensions table through Rest APIs.
Can we create calculated columns through Rest API? And what about the Calculation group.Can we create Calculation groups through Rest API?
Hi Anonymous,
#1, Calculate fields are based on DAX formulas, it required AS data engine, so you can't use the rest API to create it.
#2, AFAIK, calculate group are host on the date model, it also not able to be changed by rest API.
Creating Calculation Groups in Power BI Desktop - SQLBI
Regards,
Xiaoxin Sheng