Can't visualize a calculated column in Direct Query

[Anonymous]

Can't visualize a calculated column in Direct Query while i can visualize the same column if i use the import method.
I am using postgresql db to connect.

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

There's some Limitations when using direct query.

• Limitations in calculated columns: Calculated columns are limited to being intra-row, as in, they can only refer to values of other columns of the same table, without the use of any aggregate functions. Additionally, the DAX scalar functions, such as LEFT(), that are allowed, are limited to those functions that can be pushed to the underlying source. The functions vary depending upon the exact capabilities of the source. Functions that aren't supported aren't listed in autocomplete when authoring the DAX for a calculated column, and would result in an error if used.

Please check the document below.

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#implications-of-using-directquery

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

You can not have new column in power bi. You have to think in terms of measures. Please refer to this pbix. I have created date diff in 4 manners, 2 as columns and two as measures. They way3 and Way4 are measure based and the same calculation works on the direct query.

https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0

[Tahreem24]

@Anonymous ,

You can also create a measure instead of a calculated column.

you can also learn more deets about the limitations of directquery:

https://www.sqlbi.com/whitepapers/directquery-in-analysis-services-2016/

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.