Forum Discussion
Allow Business-User to Filter data model
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
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