Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Output DAX Evaluate results to a SQL Server Database table

Happy new year everyone!   So I have a DAX query stripped from PBI report that I have re-built in SSAS. But since my application doesnt like DAX, I thought pushing the set of DAX results to a datab...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Ok so that does make sense.

     

    Only issue is how do you format such a query in sql server? how can I refer to an SSAS server instance/model to point the query at?

     

    create view  vw.DAX

    as

    Evaluate( xyz )

     

    Thanks, your helps been very appreciated thus far parry2k 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous not sure fully what you mean by pushing DAX result out. You can sure  DAX Studio tool and run DAX expression there and it will show you the output, although I'm not sure if there is option to export the result set or not.

 

But in general this approach doesn't seems right.