Forum Discussion
Helper IIchanged data source now wont load data and find key
hi guys x
i have a several visuals in powerbi that are fed via excel files on my local machine
i have now changed the data source to csv files from a sharepoint location (the datasource are loaded here automatically)
after changing the datasource to the web location i get the following error....
Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Item=sheet1
Kind=Sheet
Table=[Table]
one reason i thought it may be failing is that the sheet/tab name was different. however after reading suggestions and changing the sheet name in powerquery.....i still get the same error message. i have even tried renaming the tab to what it was called previously
please, please help guys xx
Hifstupot,
The following methods may be helpful:
1. Make sure that the columns in the file have exactly the same name, order, data format and number as the sample file, please note that Power Query is case-sensitive.
2. Sometimes an error occurs when opening a Power Query file and trying to get the data. All files must be closed before Power Query can access them.
3. Please check that the rows in the template query are referenced correctly (i.e., the primary key between the template query and the regular query is wrong and has the worksheet name hard-coded). To solve this problem, you have to delete all other columns in the query table in the template except the data column.
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hifstupot,
The following methods may be helpful:
1. Make sure that the columns in the file have exactly the same name, order, data format and number as the sample file, please note that Power Query is case-sensitive.
2. Sometimes an error occurs when opening a Power Query file and trying to get the data. All files must be closed before Power Query can access them.
3. Please check that the rows in the template query are referenced correctly (i.e., the primary key between the template query and the regular query is wrong and has the worksheet name hard-coded). To solve this problem, you have to delete all other columns in the query table in the template except the data column.
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.