Power BI Refresh Error:
Fabric Copy Activity Error 20000
What does this error mean?
The on-premises data gateway (OPDG) cannot locate a Java Runtime Environment (JRE), which is required to parse or write Parquet and ORC file formats. Copy activity fails immediately when targeting these formats through an OPDG without JRE installed.
Common causes
- 1Java Runtime Environment was never installed on the on-premises data gateway machine
- 2JRE is installed but is not on the system PATH or the JAVA_HOME environment variable is not set, making it invisible to the gateway process
- 3A gateway upgrade or OS change removed or broke the existing JRE installation
- 4Multiple gateway nodes exist in a cluster and JRE is only installed on some nodes, causing intermittent failures
How to fix it
- 1Step 1: Log in to the machine hosting the on-premises data gateway and verify whether Java Runtime Environment is installed by running 'java -version' in a command prompt.
- 2Step 2: If JRE is not installed, download and install a compatible 64-bit JRE (Java 8 or later recommended) from the official Oracle or OpenJDK distribution.
- 3Step 3: After installation, confirm that the JAVA_HOME system environment variable points to the JRE installation directory and that the JRE bin folder is present in the system PATH.
- 4Step 4: Restart the on-premises data gateway service to pick up the new environment variables.
- 5Step 5: If running a multi-node gateway cluster, repeat the JRE installation and environment variable configuration on every node, then retry the pipeline.