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
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.