Forum Discussion

Winnie2024's avatar
Winnie2024
New Member
2 years ago
Solved

Dynamic source data for dataflow

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 = Lakeh...
Dataflows
  • Winnie2024's avatar
    Winnie2024
    2 years ago

    It worked. Thanks you for your help.

v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

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.