Forum Discussion
Network drive - 'unable to connect to data source undefined' error
Hey all, I've been struggling with the error message in the screen shot below (please excuse the mix of Norwegian and English) since the beginning of the year. For context: I'm working with ...
Hey, v-easonf-msft
I got it to work by switching from using the Folder connector to using the Excel connector in Power Query instead. I also re-entered my credentials like you suggested. Thanks!
collinq
Super User
Super UserHi Anonymous ,
This is commonly an issue of "something is different" . As in, an extra field, or, more likely a deleted or renamed field. here is more lenghty explanation of this issue: Chris Webb's BI Blog: Understanding The “The key didn’t match any rows in the table” Error In Power Query In Power BI Or Excel Chris Webb's BI Blog (crossjoin.co.uk)