Forum Discussion

goncalogeraldes's avatar
goncalogeraldes
Super User
4 years ago

Creating a table with all parameters' names and values

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 availab...
Need Help
goncalogeraldes's avatar
goncalogeraldes
Super User
4 years ago

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

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

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.

  • goncalogeraldes's avatar
    goncalogeraldes
    Super User
    4 years ago

    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!