Forum Discussion

LionelR's avatar
LionelR
Frequent Visitor
6 years ago

DAX query to extract data from SSAS model filtering a specific value in a field

I am connecting to a cube in SSAS which has multiple tables linked in the Model already. I want to extract the data with specific criteria. I have tried the below DAX   Evaluate(filter('Table',[Fie...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

LionelR - Odd, I know it's possible to import data from cubes: https://radacad.com/add-or-edit-columns-when-importing-data-from-analysis-services-into-power-bi

 

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

LionelR's avatar
LionelR
Frequent Visitor
6 years ago

Hi Greg,

 

Thanks for your response!

 

I am working out how to restrict data using DAX while importing, to a specific value in a field in a model with multiple tables.

 

Do you know if I could use a different syntax? the above formula restricts and only shows data from a single table and other data from linked tables are lost.

 

Thanks

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    LionelR - No, but you could create a new query for the other table and then use the table you imported in order to either do a Merge or filter the new table coming in, effectively accomplishing what you want, I *think*. If I understand correctly, you want to import this table within only the rows you want and then have the other related tables also have only the rows that correspond with the rows in this first table that you are importing. Right?