topic Re: Dynamic source data for dataflow in Dataflow

Dynamic source data for dataflow

Winnie2024 — Fri, 29 Mar 2024 09:57:23 GMT

In my case, I want to load data into Fabric data flow.Suppose the dynamic table name can be get from one metadata table. Here is my M language code:

--First get the table name

Source = Lakehouse.Contents([]),

#"Navigation 1" = Source{[workspaceId = "12333r3r"]}[Data],

#"Navigation 2" = #"Navigation 1"{[lakehouseId = "aaefefe"]}[Data],

my_table_name = #"Navigation 2"{[Id = "est", ItemKind = "Table"]}[Data],

---Then get the data from the table name above

#"Navigation 4" = Source{[workspaceId = "6d9a79dc-e9bc-42f8-958b-e5e896744437"]}[Data],

#"Navigation 5" = #"Navigation 1"{[lakehouseId = "aa6082ce-3048-4bc0-aa16-80e06a37697d"]}[Data],

#"Navigation 6" = #"Navigation 2"{[Id =my_table_name , ItemKind = "Table"]}[Data]

#"Navigation 6"

But i got error:

Any idea?

Thanks.

Re: Dynamic source data for dataflow

v-cboorla-msft — Fri, 29 Mar 2024 10:39:56 GMT

Hi Winnie2024

Thanks for using Microsoft Fabric Community.

Apologies for the inconvenience.

If you get an Expression.Error: The key didn’t match any rows in the table in Power BI, it means that you’ve made some changes to your source file and haven’t updated them in the Power Query.

In most cases, the error arises when the Sheet’s Name is not the same on your original and destination file.

For more details please refer : How to Fix “The Key Didn’t Match Any Rows in the Table”.

I hope this information helps. Please do let us know if you have any further questions.

Thanks.

Re: Dynamic source data for dataflow

miguel — Fri, 29 Mar 2024 21:08:17 GMT

Could you please share the full query that you have for your "get table name" query? It should yield a single scalar value. Basically a text string. If it doesn't, that's what's causing the issue in the subsequent query.

Re: Dynamic source data for dataflow

v-cboorla-msft — Mon, 01 Apr 2024 05:50:24 GMT

Hi Winnie2024

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thank you.

Re: Dynamic source data for dataflow

Winnie2024 — Wed, 03 Apr 2024 02:30:10 GMT

It worked. Thanks you for your help.