can we create measure or calculated column in power bi report server with direct query mode

[kunuthurireddy]

Hi Team,

can we create measure or calculated column in power bi report server with direct query mode. please assist

Thanks

kunuthuri reddy

[v-danhe-msft]

Hi @kunuthurireddy,

Based on my research, you could create measure or calculated column in your report by using the Power BI Desktop optimized for Power BI Report Server.
Reference: https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report#step-1-inst...

After you have finished your report, you could save your report to the report server.

Reference: https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report#step-4-save...

You could also refer to below links about how to create calculated columns and measures:

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures

Regards,

Daniel He