Power Quary and VBA code

Hi ANDRII_SAV1971 ,
As they say, you can't go calling vba operations in power query. But you can trigger power query operations by using vba, you can refer to the following documentation for more specific details about the operation.

excel - How to automate a power query in VBA? - Stack Overflow

Best regards,
Albert He

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