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

[Anonymous]

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 matched more than one row in the table) can you help me to understad what could be the reason behind it  ?

[Sudeepveettil]

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]

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

[Anonymous]

Check if the account you are using for the refresh has the proper access rights on the data source.

We encountered the same error message when connecting to Databricks Delta using the Spark connector. It turned out that the access rights to the table had been dropped. Restoring the access rights solved the issue for us.

[Anonymous · Accepted solution]

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

[rocky09]

I guess, it mostly relates to Relationship between tables. Again, Try to refresh in Power BI Desktop, see if you encountered any error.