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',[Field]="Value"))

 

This has resulted in the extraction of all the fields in that particular table "Table" but does not show me the full data linked with different tables.

 

I would like to extract all the data in the model, filtering only data if the filter criteria meet condition( specific value in a particular field in a particular table "Table" show me all the data linked in the model.

 

Appreciate your help!

 

 

thanks

Lionel

Need Help

7 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    LionelR , I think this one will create a new table and that is not joined to any other table. As SASS live connection will not allow any data model changes. You may have to prefer to do all such changes in the schema in SASS

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    LionelR Can you just connect to the cube, suck in everything and then go back and filter that table in your query for that table? Use the default navigator and select everything instead of using advanced to enter your own DAX.

    • LionelR's avatar
      LionelR
      Frequent Visitor
      6 years ago

      Hi Greg,

       

      Thanks for your response! I have tried this already and successfully created a report in Power Bi desktop, but having issues publishing due to gateway error.

       

       

       

      hence, I want to import the data with specific filter criteria and be able to extract data using DAX spanning across different linked tables in the model 

       

      thanks for your help!

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        HI LionelR,

        >>Thanks for your response! I have tried this already and successfully created a report in Power Bi desktop, but having issues publishing due to gateway error.

        I guess it would relate to power bi security and privacy.
        When you working on desktop side, it has enough permission to process these functions; when you publish to power bi service side, obviously you do not have full permissions to process these queries host on power bi service. Some of the functions will be blocked due to security reasons. (this also apply to other types of script and codes such as r script, python that host in your report)

        Power BI Security#data-storage-security 

        Regards,

        Xiaoxin Sheng