PowerBI Truncating Data when exporting it

[SadieCake]

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?

[SadieCake]

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.

[v-easonf-msft]

Hi, @SadieCake 

If your dataset is in premium capacity, you can try Dax Studio which allows you to export data from the Power BI service.

Export Power BI Desktop and Power BI Service Model Data In One-Shot with DAX Studio 

Best Regards,
Community Support Team _ Eason

[SadieCake]

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]

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

[lbendlin]

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.

[lbendlin]

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