Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
BoaRoland
Regular Visitor

Power Query refresh error

I built a small app which uses two Power Queries (pulling security prices from the Yahoo Finance website). The query results are loaded into a PQ table.

When a command button is clicked the two queries are refreshed using the following code:

    Dim q As WorkbookQuery
    For Each q In ThisWorkbook.Queries
        With ThisWorkbook.Connections("Query - " & q.Name).OLEDBConnection
            .BackgroundQuery = False
            .Refresh
        End With
    Next q
    Application.CalculateUntilAsyncQueriesDone

My problem is that this code sometimes executes error free and sometimes results in:

    Run time error 1004

    Applicaiton-defined or Object-defined error

The error occurs on the line ".BackgroundQuery = False" (in red above).

Does somebody know why this code sometimes results in error 1004? 

Thanks in advance for any suggestions.

Roland

1 REPLY 1
Anonymous
Not applicable

Hi @BoaRoland 

You can refer to the followin link.

excel - VBA SQL Connections Refresh error 1004 exception has been thrown by the target of an invocat...

.refresh BackgroundQuery runtime error 1004 - Microsoft Community

 

Best Regards!

Yolo Zhu

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

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.