Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hi. I have a client who keeps encountering the error below when trying to refresh. The data source is an Excel workbook with macros (.xlsm file). Not sure what's happening and how to solve because I am unable to replicate the error locally on my PC:
Thanks in advance for any help.
Or desktop? You can enable tracing in power bi desktop and check detailed error message.
https://ruiromanoblog.wordpress.com/2016/01/08/power-bi-desktop-trace-logs-analyser/
Paul Zheng _ Community Support Team
All sorted now: it was down to a #VALUE error in the source data. Thanks for all suggestions.
Shared capacity or Premium?
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.