Forum Discussion
Filtering SQL Server Analysis Services database in import mode
Hi mwegener
In that case, I cannot access the database directly.
I have found a way of filtering the database using DAX:
with this expresion:
evaluate(filter('Table1',[Field1]="INV") && [Invoice_Date]>=20190101))
I found in the following link there a similar question and the answer so I consider this topic resolved. Thanks!
Hi pratafran,
I mean use the data source of the Analysis Services database and not the Analysis Service database as the source.
Hi mwegener
In that case, I cannot access the database directly.
I have found a way of filtering the database using DAX:
with this expresion:
evaluate(filter('Table1',[Field1]="INV") && [Invoice_Date]>=20190101))
I found in the following link there a similar question and the answer so I consider this topic resolved. Thanks!