Forum Discussion
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 had hoped to let our end users update this as of date so that they can see the data for the time period in which they're currently monitoring. It seems though that you need to be the dataset owner in order to update the parameters? I don't want all the users to take ownership of the dataset all the time. I just want them to have the ability to refresh the data as of the date that they're interested in. Is there any way to do this? Or some other way to get a user selected parameter to filter a sql query?
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.
4 Replies
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.
Hi leahschneider ,
Unfortunately, by limit , only the owner of the dataset can modify report parameters on the service. You can post your idea to Ideas .
https://ideas.powerbi.com/ideas/
When more people vote for the idea, the product group will consider updating the feature in the new version.
An ad-hoc way to add simple parameters is by modifying the URL.
My suggestion is that users can download the PBIX file, open it in Desktop, and edit the parameters in Power Query.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Adding parameters to the url doesn't solve the problem of I need to not download the entire database into Power BI every single time. That is crazy resource intensive and time consuming. I need to use parameters in order to get a selection of the database into Power BI. This does work in Excel BTW.
Hi leahschneider ,
I understand what you mean, but unfortunately the current version does not implement the feature.
You can post your idea to Ideas .
https://ideas.powerbi.com/ideas/
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
