I have an issue with refreshing reports within Power BI Service via the (enterprise) onpremise data gateway.
When updating the dataset of the affected reports manually or on time, the error message "Cancel when sending or receiving a request" appears. (see screenshot below)
At that time, the gateway logging gives me this error message: „Failed to parse gateway core config file: The object reference was not set to an object instance.“
Only a couple of reports is affected by this issue. Other similar reports are updating properly via the gateway.
The reports were developed in Power BI Desktop as Import Mode. Data source are flatfiles within a onpremise fileshare.
The data source information in the report and the gateway configuration (power bi service) is identical.
Affected reports can be properly updated locally via Power BI Desktop and there are no errors in the data model or the loading path.
Does anyone have an idea to solve this problem? Has anyone already had a similar issue?
Thank you in advance for any hints!
thank you for message and sorry for my late reply!
In the meantime we reinstalled the gateway several times and also updated it to the latest version.
The issue still remains and now more reports are effected - but still not all.
MS support is also on this topic, but still without results. So if there is anybody out there who had a similiar issue, please let me now. :-)