How to automate a power query in VBA?

Question

How can I automate in VBA,so that i can run my Power Query automatically and copy this format into the sheet2

Answer 1

Add this formula then refresh and then connect

Dim pqFormula as String
pqFormula = "let..in"

Dim pqName as String
pqName = "<Name of the connection>"

' Update the formula for the specific power query.
ThisWorkbook.queries(pqName).Formula = pqFormula

' Refresh the connection
ThisWorkbook.Connections("Query - " & pqName).Refresh

Want to learn more about Power BI? Check out today: Power BI course