Error when trying to view queries of a Data Flow exported

[filipenovaims20]

Hi everyone,

I exported a data flow from an outside workspace so I can be able to see all the queries applied and replicate for my own purpose. For that I followed these steps: 1) Opened a new data flow then choosed the option "import from a power query template", 2) choosed the exported file in my docs, 3) copied my Workspace and Lakehouse Id then pasted in the advanced queries editor in the sources (replacing these two from the original workspace and lakehouse), 4) configured the connection to my lakehouse.

It turns out I'm getting this error and I'm not able to see any of the queires applied:

Details:

---------- Message ----------
Expression.Error: The key didn't match any rows in the table.

---------- Session ID ----------
863739d3-96fd-4b7c-a19d-de7e8bd72120

---------- Request ID ----------
334aaff0-a80e-4109-a0b3-dc79064a2be8

---------- Mashup script ----------
section Section1;
shared orders_details_imsales_oltp = let
Source = Lakehouse.Contents(null){[workspaceId = "fedc831f-7212-48b9-be18-b7b49a95688c"]}[Data]{[lakehouseId = "b827b52a-55e8-4779-bcf8-8cce28bb868d"]}[Data],
#"Navigation 1" = Source{[Id = "orders_details_imsales_oltp", ItemKind = "Table"]}[Data],
#"Replaced value" = Table.ReplaceValue(#"Navigation 1", ",", ".", Replacer.ReplaceText, {"UnitPrice", "Discount"}),
#"Changed column type" = Table.TransformColumnTypes(#"Replaced value", {{"UnitPrice", type number}, {"Discount", type number}}),
#"Merged queries" = Table.NestedJoin(#"Changed column type", {"OrderID"}, orders_imsales_oltp, {"OrderID"}, "orders_imsales_oltp", JoinKind.LeftOuter),
#"Expanded orders_imsales_oltp" = Table.ExpandTableColumn(#"Merged queries", "orders_imsales_oltp", {"ClientID", "StaffID", "OrderDate", "ShipVia"}, {"ClientID", "StaffID", "OrderDate", "ShipVia"}),
#"Reordered columns" = Table.ReorderColumns(#"Expanded orders_imsales_oltp", {"OrderID", "ClientID", "ProductID", "OrderDate", "ShipVia", "StaffID", "UnitPrice", "Quantity", "Discount"})
in
#"Reordered columns";
shared orders_imsales_oltp = let
Source = Lakehouse.Contents(null){[workspaceId = "29c30bea-0c3b-47f9-9d0e-53eb7820f063"]}[Data]{[lakehouseId = "ae4c9ac4-d044-46da-b026-875e9356370c"]}[Data],
#"Navigation 1" = Source{[Id = "orders_imsales_oltp", ItemKind = "Table"]}[Data],
#"Changed column type" = Table.TransformColumnTypes(#"Navigation 1", {{"OrderDate", type date}})
in
#"Changed column type";

Tried to apply solution to similar problems I found here, but it didn't result.

[filipenovaims20 · Accepted solution]

Hi @v-nikhilan-msft thank you for your help.

Unfortunately at the moment I can't check the exact names of the tables in the external workspace I want to consult, but I do think this the key point. I'll let you know if I have more question, for now, I'm fine.

[v-nikhilan-msft]

Hi @filipenovaims20 
Thanks for using Fabric Community.
The key didn't match any rows in the table: This error typically indicates that the query is trying to access a table or data that doesn't exist or has been modified.

Troubleshooting Steps:

1. Verify Table IDs:

   • Meticulously check the table IDs ("orders_details_imsales_oltp" and "orders_imsales_oltp") in the script against the actual table names and IDs in your lakehouse. Ensure exact matches, including case sensitivity.
   • Reconfirm these IDs in the Advanced Query Editor.

2. Review Data Availability:

   • Confirm the existence of the referenced tables in your lakehouse. If they're absent, create them or adjust the query to reference existing tables.
   • If tables exist but lack data, the query might yield the error. Populate the tables with data.
     
     

If the issue still persists please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support
Please provide the ticket number here as we can keep an eye on it.
Thanks.

[v-nikhilan-msft]

Hi @filipenovaims20 
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks