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 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorry how do you mean 'Views'? are we talking SQL Server table Views?

 

 

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous yes, and reason I mentioned that because you can have business logic in those views (translate DAX in those views)

  • Anonymous's avatar
    Anonymous
    Not applicable
    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 

    • afoss's avatar
      afoss
      New Member
      5 years ago

      Did you find a solution for this? I have a similar issue, so if you managed to solve it, could you maybe post the script for the view you used?

       

      Best regards.