Forum Discussion
Power BI server (March 2018 released version) Direct Query CANNOT use built in DAX functions
What data source are you trying to query? If it's a database, then you would have to use SQL and not DAX in the query. If its PowerQuery then I have no idea.
Thanks for your response, however, I don't think we are on the same page here. Let me explain, all my datasets are ready for report in SQL server as a view, which I can use direct query option to connect via PBI connection. The reason I use DAX is for the on screen calculation when user multi-select different charts and graphs. Now, I want to point one thing out that, it works when I use the normal PBI which is connected to the O365. But it won't work when I deployed it to the PBI on-premise server. Hope that clarifies things. Again, it's not connection issue and I do not want to use "Import mode" though I know it will work. Thanks.