Forum Discussion
Edit DAX after downloading incremental refresh model
Yes, you can generate new columns, tables and measures in Service.
There is an option (you have to enable this option to each workspace separatly) "Open data model" (click on the famous ... next to your dataset and look out for it) on every dataset which allows you to gegerate calculated tables, columns and measures in your model in Service.
If you are using XMLA connections (ALM, TE work this way) this option is disabled.
I reccomend to use TE 🙂
Even if in my tenant setting the option is enabled, the Open data model button is greyed out. Maybe beacause Incremental refresh is enabled in my datamart and there are limitations?
Tried to connect with both azure data studio and tabular editor pasting the datamart link but with server unreachable error. Opened both ports since documentation is not very clear "Datamarts use port 1948 for connectivity to the SQL endpoint. Port 1433 needs to be open for datamarts to work.", but still not working and detected some traffic over 2383 when trying to connect from tabular editor. Still can't see field parameter or add calculated dax column anywhere.