Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Dear members,
Thanks a lot for your time. I am using VBA to refresh power query embedded in Excel, but sometimes will got this error message. Anyone has encountered this situation before?
The VBA code:
The error message in VBA:
The status in Power Query, seems refresh cannot be finished
Best Regards,
Maggie
As the error message states - if a refresh is currently happening any additional refresh requests will be ignored until that refresh is complete.
Thank you for your response! Is there a way to stop the refresh without reopening the Excel? Usually it should be completed within several seconds, but sometimes the refresh of this query will take long time (cannot stop), so this error message pops up.
I would like to refresh this Query only, would not refresh other queries.
I am not aware of a way to stop an ongoing refresh, apart from stopping and restarting the capacity your dataset is on.
Have you looked into refreshing partitions via XMLA endpoint?
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 8 | |
| 8 | |
| 6 | |
| 6 | |
| 5 |