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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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?