Forum Discussion

SadieCake's avatar
SadieCake
Frequent Visitor
4 years ago

PowerBI Truncating Data when exporting it

When importing the data in PowerBI and validating the source data, the row count matches completely. However, when I export the data, it truncates 102/104 rows of the data. Not sure why that happens when I only have upwards of 7 thousand rows of data. I have not even exceeded the row count. Is there a setting I should change with regards to exporting data that would allow for the total row count?

Need Help

6 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Please provide a more detailed explanation. What are the column types? What is the maximum contents of each column? 

  • SadieCake's avatar
    SadieCake
    Frequent Visitor
    4 years ago

    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.

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      Let'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.

      • SadieCake's avatar
        SadieCake
        Frequent Visitor
        4 years ago

        I'm not sure if my dataset is at premium capacity....not sure if I even know how to check that. But I will definitely use the reference you provided to me to try to check if this is indeed the issue. I truly appreciate your response. And as soon as I have a second to do so, I will repond back on whether or not this resolved the issue. THANK YOU SOOOOOO MUCH!