Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Data source error The key matched more than one row in the table

Hi, I'm refreshing my report in the desktop environment successfully but upon publish the report on the workspace and try to refresh the data set it gives me this error (Data source error The key ma...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Thanks, the problem solved automatically yesterday, the issue was mainly in the SharePoint where the data sources located.

Sudeepveettil's avatar
Sudeepveettil
Frequent Visitor
6 years ago

Hi All,

 

I am having a similar issue.

 

We have an OData feed from (Planview) PPM Pro to Power BI. We created two reports in PPM Pro 1) Project information with financials 2) Project KPI trend data. We initially had both these reports running under two seperate dashboard. Both these dashboards are running fine independently, but when we combine both reports into one dashboard, I am getting the following error.

"Expression.Error: The key matched more than one row in the table. Details: Key= EntityKey=Project__xxxxxxx@yyyyyyy Table=[Table]"

 

In the Odata feed, both report source is showing same "EntityKey", any idea how this is getting created?

 

Regards,

Sudeep

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I am having the same problem with Planview Pro connection.  Did you find a solution?