Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Allow Business-User to Filter data model

Hello! I'm looking for a way to allow a business-user to filter out specific values in a given dimension. I'm using a Data Flow to bring in our dataset from Snowflake. From there, for testing-purpose...
Need Help
Mikelytics's avatar
Mikelytics
Resident Rockstar
3 years ago

Hi Anonymous 

 

If I understand correctly you want to make sure that the data from the dataflow are filtered before they will be provided to other users, right? and you use an excel document to define the permission rules.

 

So if you have Power BI Premium you could implement additional Dataflows based on your main Dataflow from Snowdflake. You create a new data flow, connect to the mainflow, bring in the Excel data and define your logic.

 

Other option would be to create directly in the beginning multiple dataflows based on snowflake to meet your individual target groups.

 

Other option would be to use Row-level-security but for that you need to build a dataset using Power BI Desktop which from my understanding you do not want to do, right?

 

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.