Forum Discussion

bajee's avatar
bajee
Kudo Kingpin
8 years ago
Solved

Using Direct Query mode can we create calculated measures or columns?

Hi Team,   Is there any way to create calculated measures or columns using direct query.   Regards, Bajee.
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    bajee,

    What is your data source?

    If you connect to SQL Server database using DirectQuery mode in Power BI Desktop, you are able to create calculated measures or columns. If you connect to SSAS database using “Connect Live” mode, you are only able to create measures in Power BI Desktop.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

bajee,

What is your data source?

If you connect to SQL Server database using DirectQuery mode in Power BI Desktop, you are able to create calculated measures or columns. If you connect to SSAS database using “Connect Live” mode, you are only able to create measures in Power BI Desktop.

Regards,
Lydia