Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Create calculated columns in direct query

    Vote (37) Share
    Luiz Florencio's profile image

    Luiz Florencio on 28 Apr 2017 22:35:15

    Please, improve funcionalities in models with direct query. Like add calculate columns, time intelligence, and others resources.
    Awesome, great solution.

    Comments (2)
    Luiz Florencio's profile image Profile Picture

    Alek Cannan on 13 May 2021 14:16:16

    RE: Create calculated columns in direct query

    This is an important feature. DAX is very powerful and allows us to create advanced analytics in desktop/import mode, often using calculated columns and tables. Composite models are also a major, recent game-changer. But the current limitation that we cannot create/refresh composite models with Calculated Columns/Tables on the DirectQuery side is very inconvenient and reduces the power and capabilities of analytics in PBI. Please add support for Calculated Columns/Tables in DirectQuery composite models.

    Luiz Florencio's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:27:20

    RE: Create calculated columns in direct query

    Agree, this is a highly desirable feature as creating calculated columns when connected to HANA is a typical use case we are running into.