Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
DALI007
Helper I
Helper I

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 a message stating that they did not contain any rows, even though they appeared to be filled in Gen1. I would like to know if someone could help me understand what is causing this issue please
Sans titre.png

1 ACCEPTED SOLUTION

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.

View solution in original post

5 REPLIES 5
DALI007
Helper I
Helper I

Hello v-cboorla-msft,
After several attempts to delete and recreate DataFlowGen2, I was able to recover the data, but with errors. I received the following error message: 'Error: DataFormat.Error: We couldn't convert to Number. PMI. RootActivityId = 486dc079-89cf-4a49-aaba-85353fc28cb1. Param1 = DataFormat.Error: We couldn't convert to Number. PMI Request ID: ecd3980c-3010-7389-8d8a-6e2b2d714ea3.'
It should be noted that among my fields of type NUMBER, named NUMERO, this field does not contain any empty or null values, and only contains integers. Do you have any ideas on what could be causing this issue?
ERROR type.PNG
Thank you in advance for your assistance.

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.

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.

DALI007
Helper I
Helper I

Hello v-cboorla-msft,

Thank you very much for your feedback. I refreshed the first dataFlowGen1 (in my case called dataflowGen1 named MAM_DATAFLOW_SOURCE, we can see the data in the table as shown in the first attachment). However, when refreshing the second dataFlow Gen2 named MAM_DataFLOW (second attachment) , I still get the error message "table does not contain any rows" and an empty table.
Best regards
Attachment1.pngAttachment2.png

v-cboorla-msft
Community Support
Community Support

Hi @DALI007 

 

Thanks for using Microsoft Fabric Community.

Apologies for the inconvenience that you are facing here.

After creating the Second dataflow, please refresh the First DataFlow to make data loaded into the entity. Then, click the "Refresh" button in "Navigator" pane. 

Please refer to the documentation for more information.

 

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

 

Thanks.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

November Update

Fabric Monthly Update - November 2024

Check out the November 2024 Fabric update to learn about new features.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.