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
Icon for Community Champion rankCommunity 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