Forum Discussion
Issue Regarding Power BI service
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 Team
If 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.Hi Anonymous,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.
Thank you.Hi Anonymous,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.