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 ...
Need Help
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!

      • lbendlin's avatar
        lbendlin
        Super User
        4 years ago

        you can look if your workspace name has the gem icon.