Latest Enterprise DNA Initiatives


Clearing Parameters set in Power Query

Hi:
I’m working my way through the tutorial on Data Transformations & Modeling. In a prior video while working in the Power Query Editor we set up parameters that filtered the data by currency, channels and years. Subsequently, the data is always filtered by these parameters even when they are blank. 2 questions: 1. Is this really a good practice? I can understand using it temporarily to look at a subset of a large dataset. 2. How do you modify the parameters in such a way that they include all transactions?
It seems like in order to continue with the tutorial and see the same results that Sam sees I need to delete the parameters.

Parameters are hard to interact with for ‘users’. If you are working in the file in Power BI Desktop you can change the Parameter by going to the Home tab, Edit Queries and select Edit Parameters.

From within the Power BI Service, the only way to change a Parameter is by going to that reports Workspace, Dataset (select the elipsis …), choose Schedule Refresh and there you’ll find Parameters.
I believe your Parameter must be either type Text or Decimal to be able to be changed, not very user friendly.

Usually slimming down the amount of columns is a good idea, getting rid of redundant information or data columns which don’t add much value to the analysis being completed in Power BI. The next step, if possible is to reduce the amount of rows and/or columns using SQL for example when working with very large database tables.

The other option you have is working with direct query, but this presents other restrictions.

Or maybe if it’s user specific Row Level Security?

Quick and dirty solution, just remove the filter step from the Applied Steps pane.
It will depend on your filter and what possible values there are but I wouldn’t go down that road…

Do you have a clear usecase in mind or is this just intended as an inquery into available options?

I hope this is helpfuf

2 Likes

Thanks for working on a solution on this post @Melissa.

Hello @mpchean , did the response above solve your query?

Please don’t forget if your question has been answered within the forum it is important to mark your thread as ‘solved’

Hello @mpchean, it’s been a while since we got a response from you. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

Thank you Melissa.
I think this clears up the issue for me. I have no use-case - it is part of the EnterpriseDNA tutorial. From what you have said the parameters are most useful in the exploratory phase of the process, and are too hard to change subsequently. In subsequent videos in the tutorial the complete data set is displayed, and this wasn’t happening for me. My conclusion is that I should delete the parameters to continue with the tutorial. @EnterpriseDNA this might be a good thing to point out in the Data Transformations & Modeling tutorial.

Thank-you again,
Mike

1 Like

Thanks for the feedback @mpchean. It’s great to know that you are making progress with your query.

Do you need further help with your question?

Please don’t forget if your question has been answered within the forum it is important to mark your thread as ‘solved’. Thanks!

Hi @mpchean, due to inactivity, a response on this post has been tagged as “Solution”. If you have any concern related to this topic, you can create a new thread.