Power Query-6.1203.1221

Power Query-6.1203.1221

Power Query

Power Query

Power Query with this plug-in can List, Modify, Replace and RefreshPower Query Formula.

Author  Arun Kumar (arunk@argos-labs.com

Need help?

Technical contact to tech@argos-labs.com

 

May you search all operations,

Input (Required)

Funtion Type

Parameters

Output

Funtion Type

Parameters

Output

List Queries

Select File

queries name list

Modify Query

Select File

success message

 

Query Name

 

 

Query Formula Text

 

Replace Query

Select File

success message

 

Query Name

 

 

Old Text

 

 

New Text

 

Refresh Data

Select File

success message

 

Query Refres Time

 

Return Value

Normal Case

Description of the output result

Return Code

  • 0 Success

  • 1 Exceptional case

  • 98 error

 

Output Format

You may choose one of 3 output formats, below

  • string(default)

  • Csv

  • File

Parameter setting examples (diagrams)

Operations

List Queries:

 

 

Modify Query:

Replace Query:



Refresh Data: