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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
Can some one please help? I am connecting to a SP Online list. When I refresh manually, the dashboard updates. However, on scheduled refresh, I keep getting the following error. Please note that the SP Online 'Approvers' list has not been manipulated in anyway.
| Message: | The column 'ID' of the table wasn't found. Table: Approvers. |
| Cluster URI: | WABI-WEST-US-redirect.analysis.windows.net |
| Activity ID: | 424137fc-6e95-4225-8b17-946da3de5431 |
| Request ID: | d553f93d-ba1d-426f-82fe-c7f95bbf90a2 |
| Time: | 2018-02-12 05:17:24Z |
Hi @Anonymous,
Please open the .pbix file in desktop, and check the applied steps one by one in Query Editor to see if there existing any error message.
Regards,
Yuliana Gu
Hello,
I checked each step in the Query Editor for the Approvers table and there are no errors. The only 2 steps are OOTB - Source & Navigation. Is there anything else I can try?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!