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