Forum Discussion
Dataset refresh based on Dataflow failing
Hi Gao,
I finally was able to resolve the data refresh issue. I believe I was pointing to the incorrect dataflow name in one of the datasets. I have 2 datasets in two different workspaces and they were both pointing to the same dataflow. Once I cleared this up, all seems to be working fine. thanks!
Hi rrhascall ,
1. Does the dataflow reside in a premium capacity workspace or a shared capacity workspace?
2. The underlying error message shows that the key value does not match any of the rows in the table. See if this can help you.
The key didn’t match any rows in the table
3. Try re-editing your data source credentials, even though it appears to be working fine.
Best regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi Gao,
Thank you very much for your reply!
The dataflow resides in a shared capacity. It contains just 4 small dimension tables so I don't believe the size is an issue.
I checked out the link you provided but it only refers to Excel sources. The source for my dataflow is Oracle.
Not clear on what you mean regarding re-editing the data source credentials. On the dataflow? I've tried deleting and re-creating the dataflow with the same credentials but it didn't help. Doesn't look like you can edit the existing credentials on a dataflow? The dataset refresh that is failing is connecting to both the dataflow and other Oracle tables. There is not an option to edit the credentials. It shows as follows:
Hi,
Here are the details of the dataset refresh I'm receiving. I've tried recreating the queries in the dataflow and still getting this refresh error on the dataset that is referencing the dataflow.