How to export or display more than 100 Columns

[mikoal]

Hi there,

I am working on 100 million + rows of data and after filtering, I get an ending result of 250+ columns.

Is there a way to display that or at least export that data out in a matrix (not converting it into a table)?

In addition, since I'll have more than 50,000 rows, is there an export that does not sample the data?

Thanks.

Power BI forums

4 questions posted

0 Solutions so far 😫

[Anonymous]

I Have Same issue now. Does this issue has any solutions?  @Microsoft

[mikoal]

I tried to play around with the paginated report, but i dont think this resolves the column limit.

[amitchandak]

@mikoal , Please check if paginated reports can help

https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-b...