Forum Discussion
How to create CG Measures , Date Dimension Table , Calculated Columns through Rest API .
Hi Experts, My Client wants to create Power BI Dataset through Rest API. Our Data Source Is Azure SQL Server. I have found some documentation to Push the dataset from Source to Power BI Service Her...
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