The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Firstly, the refresh of the reports was working until recently and to my knowledge nothing had actually changed.
The first I heard about there being an issue is that my customer had noticed data wasn't refreshing in reports (they are the admins so I don't receive the emails of failed refreshes).
The error they're receiving for one of their datasets, but all are affected:
{"error":{"code":"DM_GWPipeline_Gateway_SpooledOperationMissing","pbi.error":{"code":"DM_GWPipeline_Gateway_SpooledOperationMissing","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Contract Deliveries/Returns.
The 'Table' component of the error changes.
I've checked that the gateway (Standard, not personal) is running and up-to-date. The data loads perfectly in the desktop app and I can authenticate through the datasource I configured for the gateway. I'm at a loss as to what is causing this.
Does anyone have any ideas what might be causing this?
Hi @the1ben
Since April 2023 there have been major updates on Power BI Gateway. here is the latest
https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-september-2023-release/
If you say that nothing has changed until recently then you should update the gateway to the latest version.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Unfortunately they are already running the latest version of the Gateway (3000.190.19 - September 2023)