I have a lot of files where I have a column which always give an error message. When I try to check, it looks like Power Query is able to handle up to 19 or 20 digits in one cell? At least when I get 21 digits in a cell, I get an error message.
To avoid this I open the files and remove the last digits in the number, before I import the files to Power BI through Power Query. Is there a better way to fix this? I've built the reports so the only thing I do is to refresh, but the issue with this column I can't find a fix for.
If you connect to the file with PQ, thus not open it in Excel, PQ should treat such a column as type "Any" (ABC123). Then you can change it to Text and PQ should remain the digits, no matter how many.
Doesn't this make any sense, you can perhaps upload a file demonstrating the type of data you are dealing with.
Thank you for the help.
These excel files is imported to Power BI and that's where I got the problem. Didn't think about the difference in importing to Power BI, and to open Power BI, then open Power Query inside Power BI and import the files through Power Query. Now updates will be easier and faster.
