Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hola amigos, tengo un problema al momento de conectar datos del Power BI a un archivo Excel.
El archivo excel es una tabla de articulos, y tiene codigos numericos y alfanumericos, los codigos alfanumericos no los reconoce el Power BI. Ejemplo
Mi archivo excel
Como se muestra en el power BI
Por favor alguien que pueda ayudarme.
Solved! Go to Solution.
Hi @RenaCel,
I make a test using your sample file.
Firstly, when importing data from Excel to Power BI Desktop, please choose "Edit" in the following screenshot to load data.
Secondly, delete the "Change Type" step in "APPLIED STEPS" .
Thirdly, click "Close and Apply", you will be able to see that the data are imported properly into Data View.
Thanks,
Lydia Zhang
Hi @RenaCel,
Firstly, this is English forum. Please help to post your question in English format.
Secondly, when do you get the above error message” We couldn't convert to Number”? Based on my test, there are no issues when importing your sample data to Power BI Desktop. However, if we try to convert the COD_ITEM column to numeric type column, the error message will occur, this is an expected behavior. We are not able to convert text-based string to number, but we can change text-based number columns from Text to numeric type.
Thanks,
Lydia Zhang
Hi Lydia, The problem is when in a column has numerical and alphanumerical data. Attachment test file File
Thanks.
Renatto
Hi @RenaCel,
I make a test using your sample file.
Firstly, when importing data from Excel to Power BI Desktop, please choose "Edit" in the following screenshot to load data.
Secondly, delete the "Change Type" step in "APPLIED STEPS" .
Thirdly, click "Close and Apply", you will be able to see that the data are imported properly into Data View.
Thanks,
Lydia Zhang
This solution is the correct! Thank a lot
Hi Lydia, thanks!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |