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,
Recently i face not consistent error when i refresh (using VBA) one of the tables which are connected to power query.
The error i receieve:
"The connection could not be refreshed. This problem could occur if the connection was copied from another workbook or the workbook was created in a newer version of Excel."
When i refresh again the table it worked fine. Furthermore, this connection worked fine for a few months till now.
VBA code:
Set ddSheet = ActiveWorkbook.Sheets(SheetName)
Set ddTbl = ddSheet.ListObjects(TableName)
Set qt = ddTbl.QueryTable
bgQuery = qt.BackgroundQuery
With qt
.BackgroundQuery = False
.Refresh
.BackgroundQuery = bgQuery
End With
Power query version: 2.76.5678.581 64 bit
Excel version: Version 2001 (Build 12430.20264)
Hi @Anonymous
I'm not familiar with VBA code.
It seems this code you provided is to refresh power query,
As tested, there are similar threads to complete this feature in power query:
VBA ListObject..Refresh BackgroundQuery:=False not working in Excel O365
https://www.mrexcel.com/board/threads/powerquery-macro-refresh.1075922/
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for the answer, but this code is running for couple of months just fine,
Also now is running without any problems on other users PC, so i think this is not the problem.
It generate this error only on one user and also not consistent. on several workbooks having different power query tables.
I thought it's something with the office version not up to date but i installed the last update and it stll generating this error.
Still getting this error.
Any ideas?
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.
User | Count |
---|---|
100 | |
51 | |
19 | |
12 | |
11 |