How to load query function hyperlinks into excel to get same Invoke functionality

[Anonymous]

Hey legends,

I inherited a confidential query file with functions, that becomes links to invoke parameters in the query editor. Is there a way I can get that functionality into excel as links when I download.

As a sample example as I am learning, I found this other day, in blank query  =#shared will spit out all the M language [Table] and [Functions]. 

I tested this by converting the output records into table and tried to do vlookup() to extract relevant matches along with query functionality

This becomes links and Invokable functions in query but in excel, I cannot even filter them. I have the same function in my query =>

Question is I want these as similar links in excel as I have to do some lookups to create a new query that has same functionality, but they are becoming text  excel lookup and I have to create a second help to get conditional vlookup() in Query

Please can you help ?

[Anonymous · Accepted solution]

Thank you @Anonymous 

This helps. This along with other supplementary question regarding the "meta-data" should help me to think about alternatives as mentioned.  thanks

[Anonymous]

Hi @Anonymous ,

It seems like you are trying to create links in Excel that invoke parameters in the query editor. Unfortunately, it is not possible to create links in Excel that have the same functionality as in the query editor. However, you can use the M language used in Power Query to create many commonly used formulas such as add custom columns, table conversions, etc.

You mentioned that you tried to convert the output records into a table and use vlookup() to extract relevant matches along with query functionality. However, the links and invokable functions in the query are becoming text in Excel and you cannot even filter them.

If you want to create a new query that has the same functionality, you can try to use the M language in Power Query to create the necessary formulas. Unfortunately, it is not possible to create links in Excel that invoke parameters in the query editor. However, you can try to use the M language in Power Query to create the necessary formulas.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.