---
title: "Why does Prism say “Failed while retrieving data from the…"
description: "Prism cannot read the data change source—often missing Prism: Manage File Containers, report access, or an inactive security change. Fix security and rerun."
url: https://kiweely.com/guides/workday-prism-failed-while-retrieving-data-from-the-source
---

# Why does Prism say “Failed while retrieving data from the source”?

Failed while retrieving data from the source means Prism could not read the data change source. Confirm report or connection access, Prism: Manage File Containers for files, and activated security.

-   **Checked** against Workday on November 17
-   Applies to **Workday Prism Analytics data change tasks**
-   2 min read
-   Published November 17
-   By Kiweely

**Failed while retrieving data from the source** means Prism’s data change activity could not read the source you configured—file, connection, or Workday report. It is a retrieval failure, not a mapping typo after the rows were read.

## Security Workday requires

Workday’s Prism security concept controls data change task access from three sides:

1.  **Target table permissions** compatible with the operation (for example insert and update for upsert).
2.  **Source access**—view permission on the custom report, source dataset, or SFTP connection. File upload does not need view permission on a catalog source, but it does need file-container rights.
3.  **Domain rights** for the kind of source you use.

Create a Data Change Task documentation calls out **Prism: Manage File Containers** in the Prism Analytics functional area when uploading a file, and **Prism: Manage Connection** when using a source connection. Education material repeats the same file-container requirement for attaching a file to a data change task.

| Symptom pattern | Check first |
| --- | --- |
| File upload source fails | Prism: Manage File Containers on the running user’s group; activate pending security |
| SFTP / cloud connection fails | Prism: Manage Connection; connection Restricted To matches the current environment |
| Custom report source fails | User can view the report (owner or shared); report enabled as web service and for Prism |
| Works for one admin, fails for another | Compare domain grants and table permissions, not only Prism role labels |

## Report sources: configuration that must already be true

To use a Workday report as a table or data change source, Workday requires all of:

-   Advanced report
-   Enabled as a web service
-   **Enable for Prism** on the Advanced tab

Workday fails a data change activity when a report source returns more than 30,000,000 rows. Business-view (formerly combined) data sources are not supported for this path.

If someone edits the report schema—adds or removes fields or changes types—Workday **desynchronizes** the data change task even when those fields are unmapped. The task then fails or is skipped on schedule until you update the task to match the report again.

## Fix steps

1.  Confirm who runs the activity. Prefer that user’s direct session when testing, not a proxy, so you see their real domain set.
2.  Verify source access: open the report or connection as that user.
3.  For file-based loads, grant **Prism: Manage File Containers**, then run **Activate Pending Security Policy Changes**.
4.  For report sources, confirm advanced + web service + Enable for Prism, and that the user owns or is shared on the report.
5.  Confirm table permissions match the operation type.
6.  If the report schema changed recently, open the data change task and refresh mappings so Workday resynchronizes it.
7.  For SFTP, confirm address, directory, filename pattern, and that **Restricted To** matches the environment running the activity.

Kiweely Vine can answer Prism and security questions against Workday documentation and, with consent, help you inspect tenant configuration. Loading Prism tables still happens inside Workday.

## Frequently asked questions

### I own the Prism table and the report. Why does retrieval still fail?

Owning the table is not enough. You also need source view permission, table change permissions that match the operation, and—for file upload—Prism: Manage File Containers.

### What report settings does Prism require?

An advanced report, enabled as a web service, with Enable for Prism selected on the Advanced tab.

### Can a report schema change break retrieval?

Yes. Workday desynchronizes a data change task when the source report schema changes, and the task fails or is skipped until you update the task to match.

## Sources checked

-   [Create a Data Change Task](https://doc.workday.com/admin-guide/en-us/reporting-and-analytics/prism-analytics/changing-data-in-tables/mah1633019920264.html)
-   [Concept: Security in Prism Analytics](https://doc.workday.com/admin-guide/en-us/reporting-and-analytics/prism-analytics/securing-data-in-tables-and-datasets/bwd1502220225338.html)
-   [Concept: Creating Reports to Import into Tables and Datasets](https://doc.workday.com/user-guide/en-us/workday-prism-analytics/wfz1502216113528.html)
-   [Concept: Data Change Tasks](https://doc.workday.com/admin-guide/en-us/reporting-and-analytics/prism-analytics/changing-data-in-tables/wzk1633019974433.html)

## Related guides

[All guides](https://kiweely.com/guides)

-   [### Workday Data Cloud vs. EIB, RaaS, and Prism: Which Data Path Should You Use? Use Workday Data Cloud when Snowflake, Databricks, or BigQuery need zero-copy Iceberg or live SQL access to Workday tables without custom extract pipelines. Keep EIB and RaaS for vendor file deliveries, calculated-field payloads, and custom objects not yet in the Data Cloud Catalog.](https://kiweely.com/guides/workday-data-cloud-vs-eib-raas-prism)
-   [### Loading and reading Prism Analytics tables from a Workday orchestration To load Prism from Orchestrate, create a file container, upload a gzip-compressed delimited file, then run an existing data change task against it with POST /dataChanges/{id}/activities and poll the activity until it succeeds. To read, publish the table as a Prism data source and query it with WQL.](https://kiweely.com/guides/workday-orchestrate-prism-datasets)
-   [### Workday Prism Analytics vs. WQL vs. Custom Reports: Joining External and Tenant Data Prism Analytics blends external and Workday data into published Prism data sources, while WQL and Custom Reports query live tenant business objects. Here is how to choose between them, how Prism’s five-phase security model works, and what limits apply to Prism reports and calculated fields.](https://kiweely.com/guides/workday-prism-analytics-vs-wql)

### More guides on Reports and calculated fields

[All 25 guides](https://kiweely.com/guides#reporting)

-   [Why a Workday calculated field fails inside a condition rule or Term BP](https://kiweely.com/guides/workday-calculated-field-fails-in-condition-rule)
-   [Prove an AI-suggested Workday calculated field before it drives a condition rule](https://kiweely.com/guides/ai-workday-calculated-fields-condition-rules-proof)
-   [Life-Event 834 Feeds for Birth, Divorce, and COBRA](https://kiweely.com/guides/life-event-834-feeds-for-birth-divorce-and-cobra)
-   [Expense Report Create-and-Submit Screens Outside Workday Menus](https://kiweely.com/guides/expense-report-create-submit-outside-workday-menus)
-   [Workday calculated field not showing in a report: why it is missing from the field picker](https://kiweely.com/guides/workday-calculated-field-not-showing-in-report)
-   [How to debug a Workday calculated field that returns the wrong value](https://kiweely.com/guides/workday-calculated-field-returns-wrong-value)
-   [Preventing Accidental Indirect-Report Visibility in Workday Intersection Security Groups](https://kiweely.com/guides/workday-security-groups-intersection-subordinate-org-visibility)
-   [How to Sum or Count Multi-Instance Rows in Workday Using Aggregate Related Instances (ARI)](https://kiweely.com/guides/workday-aggregate-related-instances-ari-sum-count)

### From the blog on Reports and calculated fields

[All posts](https://kiweely.com/blog)

-   [Untangling a 14-Subreport Workday Composite Report Nobody on Your Team Built](https://kiweely.com/blog/reverse-engineering-inherited-workday-composite-reports)
-   [How Consultants Catch Silent Report and Browser Regressions After a Workday Semiannual Release](https://kiweely.com/blog/regression-testing-workday-ui-and-timezone-changes)
-   [Why Deep Workday Calculated Field Chains Become Unmaintainable (and How to Audit Every Dependency)](https://kiweely.com/blog/auditing-deep-workday-calculated-field-chains)

## Let Workday check the work.

Kiweely writes WQL and builds orchestrations in your own tenant, and Workday, not Kiweely, says whether they passed.

[Start for free](https://kiweely.com/download) [See how it works](https://kiweely.com/vine/how-it-works)

## Get the next guide in your inbox.

One email a month with new guides and one Extend tip. Nothing else.
