Forum Discussion
Solved
Parameter Change from Non Owner
I have a very large dataset that is filtered in power query with an "As of date" parameter. This filter is really important since I don't want to bring out entire database into Power BI dataset. I ha...
The solution is this:
- Create an excel sheet (or anything) with one column and one value - this is your "parameter".
- Import that file into Power Query and convert to a List
- Add to queries that need parameter filters in native query "let param = List.First(ParamList),"
- Use param as a filter
- Users can now change the filter by changing the Excel sheet and refreshing
I can't imagine why Power BI devs seem to think that all datasets are going to be entirely managed by only one person. We have a tech team of 4 and like 3 other people who are Power BI power users and even this tiny team needs to have multiple "owners" on a dataset.
The solution is this:
- Create an excel sheet (or anything) with one column and one value - this is your "parameter".
- Import that file into Power Query and convert to a List
- Add to queries that need parameter filters in native query "let param = List.First(ParamList),"
- Use param as a filter
- Users can now change the filter by changing the Excel sheet and refreshing
I can't imagine why Power BI devs seem to think that all datasets are going to be entirely managed by only one person. We have a tech team of 4 and like 3 other people who are Power BI power users and even this tiny team needs to have multiple "owners" on a dataset.