cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

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

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

View solution in original post

4 REPLIES 4
Highlighted
Impactful Individual
Impactful Individual

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

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

Highlighted
Frequent Visitor

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

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.

Highlighted
Anonymous
Not applicable

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

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

View solution in original post

Highlighted
Regular Visitor

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

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Top Solution Authors