Forum Discussion

AGo's avatar
AGo
Post Patron
3 years ago

Edit DAX after downloading incremental refresh model

Hello, I uploaded my pbix to the service in order to have incremental refresh advantages. I then managed to download my pbix but only in dynamic binding mode. I can't even edit the model with the ne...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
sergej_og's avatar
sergej_og
Super User
3 years ago

Hi AGo ,
by using Premium you can also use Tabular Editor to manage model adjustments, e.g. make changes for measure.
In my point of view best practise for me.
You can connect to your model vial XMLA Endpoint (by using Premium) directly from TE, make your stuff an save your changes directly in Service.
You don´t need to download anything.

ALM Toolkit as GilbertQ mentioned could also be a good approach, e.g. for model comparison after adjsutments.

AGo's avatar
AGo
Post Patron
3 years ago

Thank you and GilbertQ for the useful answers , I hoped there was a fully integrated functionality in PowerBI Desktop. It seems that everything is founded on a solution (ALM) that is not guaranteed by Microsoft but created by a domestic business entity. Is there a way at least to create dax columns and dax tables in the service? It seems only measures can be added and I can't insert field parameter functionality anymore.

Thanks

  • sergej_og's avatar
    sergej_og
    Super User
    3 years ago

    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 🙂

    • AGo's avatar
      AGo
      Post Patron
      3 years ago

      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.