In flat table visualization (standard excel export) data is truncated when number of rows exceeds 150k. Only small, easy to overlook info is present at the bottom of excel file "Exported data exceeded the allowed volume. Some data may have been ommited"
In matrix visualizations, the problem with Excel export is exacerbated because Power BI cuts off data not just at the 150,000 rows limit, but it counts the rows multiplied by columns.
This means that even at a few hundred rows count excel can be truncated if there are many attributes in the query or a 12-month time series.
It would be extremely helpful to have an interactive warning pop up when the export button is clicked, or to have the information about the data truncation prominently displayed at the top of the Excel file, rather than at the end.
- dungp on: Enable Service Principal authentication for notebo...
- DrAWXP on: Power BI Test Mode - Temporarily Make Manual Chang...
- Martijn_Lucas on: Feature request: Running container jobs in Fabric
- matthias_vc on: Ability to Select Specific Files from SharePoint W...
-
lbendlin
on:
Fabric Copy Activity Upsert Needs Native Audit Col...
-
meechielvp60
on:
Power BI Subscriptions enhancements sorely needed
-
ThornKevin
on:
Ragged Hierarchy Display options in Matrix Visual
-
miguel
on:
Personalized Source List in Get Data
-
ThornKevin
on:
RLS testing UI (Test RLS roles directly in the ser...
- xnstatpipe on: Power BI Data Function Button - Allow submission w...