Forum Discussion
PowerBI Truncating Data when exporting it
Hope I am answering this correctly, but we have multiple data types (as columns) that I am pulling from the source data, of which, they are: Text, Number (Whole), Decimal Number, Date. Of the source data, which has 43 total columns, I am only using 16 of those columns in my table. Help me understand what you mean by the maximum contents...some of the rows contain cells in the row contain very little data while others contain alot more chararacters. So please help me understand the impact that may have.
Super UserLet's say you have a text column. It usually has content that is 100 characters long. Now for whatever reason you have an entry where the text is 17000 bytes long. That is nearly certain to break your processes.
So for each column you want to evaluate the size histogram, to see if any of your columns can be the culprit.