CODEWITHSUNDEEP
powerbipowerbi-desktoppowerbi-datasourcepowerbi-custom-visuals
Mahesh
Mahesh

Reputation: 198

POWER BI - If Calculated columns are saved back into the model and take up space(in import), how do they work in Direct query mode?

Calculated columns in power bi :

This happens in Import mode where data is loaded into model, where as in DirectQuery mode data is not loaded into model.

In such case where calculated columns are saved in DirectQuery mode ?

Correct me if am wrong...

Upvotes: 0

Views: 242

Answers (1)

Marco Russo
Marco Russo

Reputation: 179

Calculated columns are computed at query time in Direct Query mode. For this reason, there are restrictions in DAX formulas used in calculated columns in Direct Query. This white paper has more details about this and other Direct Query features: https://blogs.msdn.microsoft.com/analysisservices/2017/04/06/directquery-in-sql-server-2016-analysis-services-whitepaper/

Upvotes: 1

Related Questions