Forum Discussion
MTD without measures (Direct Query)
We are working on bringin measures to DirectQuery. Thank you for the patience :)
Meanwhile, if your MTD value can be calculated with relational algebra (demands a certain kind of schema to do this), then you can go into the queries view and add a new query to the same database, use the custom query field to write SQL for the intented value. When this query fills, it'll stay in DirectQuery mode and act like a "measure"
I agree with HarrisMalik
I was planning on changing all my Power BI files over to be setup as Direct Query however without the ability to create measures there is no point. There is no point in using Power BI without the ability to setup measures.
Stick with the Import method and just wait for some more updates to the Enterprise Gateway to provide the data connection to more up to date information.
ED
We are working on bringin measures to DirectQuery. Thank you for the patience :)
Meanwhile, if your MTD value can be calculated with relational algebra (demands a certain kind of schema to do this), then you can go into the queries view and add a new query to the same database, use the custom query field to write SQL for the intented value. When this query fills, it'll stay in DirectQuery mode and act like a "measure"
Thanks for the update pqian - looking forward to it.