![]() In particular, notice that the first step in the query (called Source) returns a table with one row for each worksheet, table and named range in the workbook: ![]() What actually happens in this query though? If you click on each of the four steps in the Applied Steps pane on the right-hand side of the screen, you’ll see what each step does. ![]() It’s very easy to do this: after you click on the Excel data source and select your Excel workbook, you see the Navigator window with the contents of the workbook and select Sheet1: ![]() On Sheet1 there’s some data you want to load into Power BI or Excel using Power Query: Say you have an Excel workbook with three worksheets in called Sheet1, Sheet2 and Sheet3: TL DR You’re probably getting this error because your Power Query query is trying to connect to a table or worksheet or something in your data source that has been deleted or been renamed. In this post I’ll explain what the error message means and when you’re likely to encounter it using a simple example. It can occur with almost any data source and in a wide variety of different circumstances, and for new users of Power Query it can be very confusing. One of the most common errors you’ll see when working with Power Query in Power BI or Excel is this:Įxpression.Error: The key didn’t match any rows in the table
0 Comments
Leave a Reply. |