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
FrancisMarquez
Regular Visitor

Datamart: Adding columns using DAX instead of PowerQuery

Hi, is it possible to add columns via DAX instead of PowerQuery on Datamart?

1 REPLY 1
pratyashasamal
Super User
Super User

Hi @FrancisMarquez ,

When the connection mode is Live Connection, model actions like build relationships, create calculations etc. are not supported in Power BI for the data source is a tabular model that can be used by Power BI directly. For such kind of data source, calculations like create Calculated columns, measures are completed in the data source. When you live connect to Datamarts, these limitations are applied as well. Fortunately, Power BI provides the ability to change the connection mode of Datamarts from Live Connection to Direct Query if you would like to calculate on connected model. With the Direct Query mode, you could build your Calculated columns and relationships.

 

Before the switch, you need enable DirectQuery for PBI datasets and AS in the Preview features and restart your Power BI Desktop.

pratyashasamal_0-1685683873874.png

 

 

Click on Make changes to this model

 

 

Then, the connection mode is Direct Query. You could create Calculated column or build relationships in this environment.

pratyashasamal_2-1685683873240.png

 

 

However, there still some considerations when creating Calculated columns with Direct Query mode. For more details, you could refer to Use DirectQuery in Power BI Desktop - Power BI | Microsoft Docs.
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C





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

Proud to be a Super User!





Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors