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-purpose...
I'm very new to Data Flows, but otherwise very comfortable with datasets and reports in Power BI.
ok, so looking on dataflow in a first place you unfortunately need Power BI Premium to bring your Excel data and the dataflow data together (before hitting Power BI Desktop) so that you are able to use it to pre-filter the data for end-users.
Lets say you have Power BI Premium then you could go with the approach with the sub data flows I described above.
Without Power BI Premium the only chance I see is to provide datasets using Power BI Desktop and put a RLS on top.
Unfortunately I have no other idea so far based on your description. sorry 😕
Best regards
Michael