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 ?
Solved! Go to Solution.
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.
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?
Check out a full recap of the month!
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.