Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello there community! I have to create a table containing all the parameters used in Power Query and its corresponding values without the use of the =#shared function because I need it to be available later on in the model and refresh it in the service. So, for example, imagine I have three parameters, I would like to have the following table in PQ:
Parameter Name | Value |
Parameter1 | abc |
Parameter2 | def |
Parameter3 | ghi |
This needs to be dynamic since the developer can later on add or remove parameters from the model and so this table needs to be updated accordingly. I have been going around this for quite some time but without any luck!
Thanks in advance for any help or suggestion given!
Best regards,
Gonçalo Geraldes
Accessing #shared in service is not supported for these. In this case, I would suggest that you should maintain the table in a separate query.
Developers can lookup a parameter thus its associated value in their queries.
Then from this table, rows can be edited or added or deleted.
My question is related to how to develop the table in a dynamic way. That is, how can I have a table which has all of the parameters and it's values?
Best regards,
Gonçalo Geraldes
The model which I am proposing is doing away with parameters as #shared will not be accessible in Power BI service. Rather than using New / Manage Parameters interface of Power Query, you should use a query to store equivalent parameters' names and values.
Even if you use Parameters, you still have to create/edit/delete parameter values manually only. Manual angle will not go away. Somebody will have to do it. The same will have to be done in the query.
This is a trade-off which I am proposing to circumvent limitation of #shared in Power BI service.
Yeah thats the system we have right now which implies manual intervention and maintenance of the auxiliar parameter table. I wa wondering of there is any way of going around the #shared issue while maintaing the automation. Thanks anyway for your help!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
7 | |
6 | |
5 |