Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a several queries from PowerQuery, and I need to refresh only specific one (by click on button).
I tried it by VBA but I don´t have a success:(.
Can you help me with correct VBA code?
Below you can see example, and link for download an experimental file.
https://uloz.to/tam/cd98e9e4-345d-41bc-b0b4-b8459aa86afc
Honza
Solved! Go to Solution.
Corect syntax for refresh one specific Query by VBA is:
SUB Macro_Name()
ThisWorkbook.Connections("Query – Name of Query").Refresh
End Sub
Hi,
no a have a correct Name of query:
Honza
Check out "DATA - Connections" for its real name in the file,
or use such a snippet to traverse the whole Connections set,
Sub DisplayNames()
For Each qry In ThisWorkbook.Connections
Debug.Print qry.Name
Next qry
End Sub
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Corect syntax for refresh one specific Query by VBA is:
SUB Macro_Name()
ThisWorkbook.Connections("Query – Name of Query").Refresh
End Sub
Hi Kopec,
I am using your code and replace the query name but keep getting the following error. Would you please enlighten me, thank you
Run-time error '9'"
Subscript out of range
Update to my own question:
I have found using a wrong variable name and that's what Error '9' is telling me. You may use the following code to run the list all of your connections/queries and I simply missed we need to add "Query - " in front of your query name, i.e. query name as QueryReport then it should be "Query - QueryReport". Hope this helps anyone with the same problem, thank you
Sub ListAllQueriesandConnection()
Dim conn As WorkbookConnection
For Each conn In ActiveWorkbook.Connections
Debug.Print conn.Name
Next
End Sub
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.