Forum Discussion
Refresh issues
I created power bi report sourced from one SharePoint folder. In query editor, I created one parameter and entered the root url of SharePoint site. And datasource settings I mde changes to point to parameter. And dataset is having around 20 tables. and now source location gets changed. So i made changes in parameter ( new root url). And in all the 20 tables, I made changes in third step named filtered rows, where the folder path is present. So i just changed it to new path. Thatsit while loading it doesn't throw error. But while refreshing throwing error like parameter1 - key didn't match any rows in table, ..
Can anyone help me fix this
5 Replies
Hi there! It sounds like you've updated the parameter and folder path, but the refresh error might still be due to how Power BI is handling the SharePoint data source.
Here are a few steps you can try to troubleshoot and fix this:
1. Check the Parameter URL Format: Sometimes, Power BI is picky with the format of the SharePoint URL. Make sure the new root URL is in the correct format (usually without any extra subfolders or query strings at the end). For example, it should look like `https://yourcompany.sharepoint.com/sites/YourSite`.
2. Clear Permissions:
- Go to File > Options and Settings > Data Source Settings.
- Look for the old SharePoint URL in the list and clear its permissions.
- Then, reconnect with the new URL so that Power BI refreshes its cached permissions with the updated location.3. Verify Table Connections: Sometimes, each table might have retained some reference to the old path. Double-check each table’s Source step in the Query Editor to ensure they all point to the updated parameter correctly.
4. Re-enter Parameter in Data Source Settings:
- Go back to Data Source Settings.
- Re-select your parameter as the data source, then reapply it to make sure it recognizes the updated URL.5. Check Applied Steps:
- For each table, verify all applied steps in the Query Editor. Sometimes an additional step may be using the old path, even if it doesn’t show an immediate error.Try these steps and let me know if that resolves it! This should refresh your dataset with the new SharePoint folder path.
getting this kind of error from sample file (2) to sample file (7). In sample file (1) getting error as key didn't match any rows in table. So how can I fix these issues. So i need help on this
These Sample files need to have the new path also. The table refer to these Sample files. If you know which Sample file is for which tablle change the path using advanced editor.
Hi Maha16 ,
The expression =#"Filters Rows"{0}[Content] is a reference to a specific element within a filtered table or list in Power Query.
Please review the filter conditions applied in the #"Filters Rows" step. Make sure the conditions are correct and do not exclude all elements from the data set.
{0}: This indicates that you are accessing the first element of the filtered result. In Power Query, indexing starts at 0, so {0} refers to the first row or item in the collection. Ensure that the collection has at least one element. If the collection is empty, accessing the first element will cause this error.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
