Forum Discussion
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-purposes, I have an excel document on OneDrive that defines which values are allowed. Long-term this would be managed by the user.
With that in mind, how I go about filtering out the dataset in Power BI? I know we could use report-level filters, but that feels too far downstream. Curious to know if there is a way to implement this in the model before it hits Power BI desktop.
5 Replies
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.
Hey Mikelytics , the only stipulation is that I want to enable our end-users to manage that list which will be used for filtering. I have the additional DataFlow set up to bring in the Excel file, so now I'm trying to filter the data based on this list. Is there a way to enable filtering in the Power BI Model without using Report-Level Filters?
Hi Anonymous
only for my understanding. Do you know the difference between a dataflow, dataset and report in Power BI?
2nd questions: What is the target regarding your users. What will they do with the data and how will they comsume it? Do they have experience in building data models in Power BI?
Best regards
Michael
