Forum Discussion

vincentn's avatar
vincentn
Frequent Visitor
8 years ago
Solved

Filter in Query editor with parameter

Hello,     For simplicity sake I'm going to explain the problem in an example scenario.   All the data from different company's is stored in one database (MySQL). Each company has its own sales...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    vincentn,

    "Goal: 

     

    First a parameter needs to be given that equals one of the company's names.

    Then you can only see data from that particular company in the data tab. So that data from other company's cannot be used when making visualisations.  "


    You can review the PBIX file about how to set filter parameter, However, to achieve  the above goal, you can also create RLS roles.



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

vincentn,

"Goal: 

 

First a parameter needs to be given that equals one of the company's names.

Then you can only see data from that particular company in the data tab. So that data from other company's cannot be used when making visualisations.  "


You can review the PBIX file about how to set filter parameter, However, to achieve  the above goal, you can also create RLS roles.



Regards,
Lydia