Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AGo
Post Patron
Post Patron

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 new functionalities (it seems because this function is not available for incremental refresh model). Now I open my pbix in dynamic binding mode on my PC and notice I have to do a little correction on one dax measure, but since the model is not full integrated I don't have data panel nor the classic options to edit a dax measure with formula bar. How can I manage this?

 

Thanks

6 REPLIES 6
sergej_og
Super User
Super User

You have to enable the option "Open data model" for each workspace separately.
I´m not sure this option has an affect on Datamarts. This option affects only Datasets.
If you use XMLA endpoint on your Datasets this option is also disabled.

Enable "Open data model":

sergej_og_0-1691735683407.png


We don´t use Datamarts because it is in preview and we had different issues using it as a trial.
So unfortunately I can not give you my expirience.

sergej_og
Super User
Super User

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.

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

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.

GilbertQ
Super User
Super User

Hi @AGo 

 

If you are using Power BI Premium or Power BI Premium per user you can update your current PBIX tool and then use the ALM Toolkit to then update your model where you just deploy the measure.

 

here are more details: Power BI external Tools – ALM Toolkit – Debbies Microsoft Power BI, SQL and Azure Blog (home.blog)

 

If you are using Power BI Pro, the only option is to open your PBIX make the change to your measure. Then upload the PBIX and let the incremental refresh get all the data in again.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors