Forum Discussion
Creating a table with all parameters' names and values
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!