Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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
Solved! Go to 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.
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?
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.
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.
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
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
Check out the November 2024 Fabric update to learn about new features.
User | Count |
---|---|
5 | |
5 | |
3 | |
3 | |
2 |