Forum Discussion

DALI007's avatar
DALI007
Helper II
2 years ago
Solved

DataFlow Gen2 : The table does not contain any rows.

Hello, I have created two different dataflows, Gen1 and Gen2. In Gen1, I added some tables from different sources and when I tried to retrieve these tables by pointing to them from Gen2, I received ...
Dataflows
  • v-cboorla-msft's avatar
    v-cboorla-msft
    2 years ago

    Hi DALI007 

     

    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.


    Thanks.

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

Hi DALI007 

 

Apologies for the issue that you are facing here.

The “DataFormat.Error: We couldn’t convert to Number” issue often arises when working with data transformations in Power Query within Microsoft Fabric.

  • Column Data Type Mismatch: This error occurs when Power Query tries to convert a value to a numeric type (e.g., decimal, integer) but encounters non-numeric data. The column likely contains a mix of numeric values and non-numeric values.
  • Identify the Problematic Column: Determine which column is causing the error.
  • Remove Non-Numeric Values: In Power Query, filter out rows where the column value is not numeric. Use the Text.Select function to keep only rows with numeric codes.
  • Change Data Type: After filtering, change the data type of the column to Text. This ensures that both numeric and non-numeric values are treated as text.

Trying to adapt these steps to your specific dataset and requirements might help you in resolving your issue.

 

For a similar case, please refer to the thread : DataFormat.Error: We couldn't convert to Number.

 

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

 

Thanks.

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

Hi DALI007 

 

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.


Thanks.