Partial data when export underlying data!! Too Many columns ?

[Anonymous]

Hi Guys,

I have data source in tabular model.I am giving LIVE connection.

I have 2 Million records and around 80 columns .I am trying to export underlying data .

The total count of rows are 90K records in DB .I use count function to count the Primary key columna i have 90K records in power bi too. But when export the underlying data , it isnt exporting all 90K records with 80 columns .

Its exporting around 40 to 50K records with 80 Columns .

When i try to export summarised data , i can also get 90K records without any problem.

I also know that the underlying works only fot TEXT value columns .I also know the total no of ROWS in .XLSX can be 150000 rows.

Are there any limitations for the number of COLUMNS when exporting underlying data ?

When i tried to remove the number of columns to 25 , i can export 90K underlying data.

 Can someone help me on this ?

[mihart · Accepted solution]

 @Anonymous 

Have you checked this document;  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

At the bottom it has info about limitations and considerations. Maybe this article will answer your question?

HTH

Michele

[Anonymous]

hi @mihart 

thanks for your suggestiuon but it doesnt mention about "COLUMNS" limitations

V

[mihart]

Hi @Anonymous 

I'll update the doc.  This is one of the reasons I like to participate in the forums -- it helps me improve my Power BI docs 🙂