Forum Discussion
Issue Regarding Power BI service
My scenario is : I have "NRPPartClassification" this file earlier with three column "PART_NO","PART TYPE" and, "MAJOR PARTS" so my requirement is replace this file with NRPPartClassification(ER1+ER2) and column is same as eralier one but in newest file one column is added by user in source file newest column is "ORG" and applied steps in editor also same,we just replced file. so when I did close and apply in editor its done successfully and reflect the data in desktop also it successfully published in service but when I applied shedule refresh it showing below error how to reslove it "Expression.Error: The key didn't match any rows in the table.. Microsoft.Data.Mashup.ErrorCode = 10061. Key = [Name = "NRP Classification Master (ER1+ER2).xlsx", Folder Path = "******************sharepoint_link********************** Documents/Documentation/Costing/GIEA/Projects/Costing BOLT ON Project/BOLTON Impacted Development Objects/Consumption Report/NRPI Consumption/"]. Table = #table({"Content", "Name", "Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}, {}). ;The key didn't match any rows in the table.. The exception was raised by the IDbCommand interface. Table: NRPPartClassification(ER1+ER2)."
Anonymous
The key didn't match any rows in the table" typically indicates that the Power BI service is unable to find the file at the specified location during the scheduled refresh. This can happen due to several reasons, such as changes in the file path, file name, or access permissions. Here are some steps to resolve this issue:
Verify File Path and Name: Ensure that the file path and name specified in your Power BI query match exactly with the file stored in SharePoint. Even a small discrepancy can cause this error.
Check Access Permissions: Make sure that the account used for the scheduled refresh has the necessary permissions to access the file in SharePoint. Sometimes, permissions might be different for the desktop and service environments.
Update Data Source Credentials: Go to the Power BI service, navigate to the dataset settings, and update the data source credentials. This ensures that the service has the correct credentials to access the file.
Reapply Query Steps: Open the Power BI Desktop file, go to the Power Query Editor, and reapply the steps to ensure that the query is correctly referencing the new file. Sometimes, reapplying the steps can resolve any underlying issues.
Check for Case Sensitivity: Ensure that the file name and path are correctly referenced with the correct case (uppercase/lowercase) as SharePoint can be case-sensitive.
Test Connection in Power BI Service: In the Power BI service, test the connection to the data source to ensure that it is working correctly.
5 Replies
- bhanu_gautam
Super User
Anonymous
The key didn't match any rows in the table" typically indicates that the Power BI service is unable to find the file at the specified location during the scheduled refresh. This can happen due to several reasons, such as changes in the file path, file name, or access permissions. Here are some steps to resolve this issue:
Verify File Path and Name: Ensure that the file path and name specified in your Power BI query match exactly with the file stored in SharePoint. Even a small discrepancy can cause this error.
Check Access Permissions: Make sure that the account used for the scheduled refresh has the necessary permissions to access the file in SharePoint. Sometimes, permissions might be different for the desktop and service environments.
Update Data Source Credentials: Go to the Power BI service, navigate to the dataset settings, and update the data source credentials. This ensures that the service has the correct credentials to access the file.
Reapply Query Steps: Open the Power BI Desktop file, go to the Power Query Editor, and reapply the steps to ensure that the query is correctly referencing the new file. Sometimes, reapplying the steps can resolve any underlying issues.
Check for Case Sensitivity: Ensure that the file name and path are correctly referenced with the correct case (uppercase/lowercase) as SharePoint can be case-sensitive.
Test Connection in Power BI Service: In the Power BI service, test the connection to the data source to ensure that it is working correctly.
Hi Anonymous,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like you are getting error in Power BI when it's trying to find a file in SharePoint but is unable to locate it. There can be many reasons for this like issue with File Name or Path, or issue with folder path or permission issues in your sharepoint. As bhanu_gautam, already responded to your query, please go through it and accept it as solution if it answers your query.
I would also take a moment to thank bhanu_gautam, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support TeamIf this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
Hi Anonymous,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.