Read more about the article How To Display More Than 1000 Rows in Excel for Power BI Datasets Pivot Table Value Double Click Drilldown
Delete MAXROWS 1000

How To Display More Than 1000 Rows in Excel for Power BI Datasets Pivot Table Value Double Click Drilldown

Here's an interesting thing people used to Excel standard Pivot Table find surprising when they create a Pivot Table off a Power BI dataset. The usual expectation when you double…

Continue ReadingHow To Display More Than 1000 Rows in Excel for Power BI Datasets Pivot Table Value Double Click Drilldown

Fully Online Delivered Business Data Analysis with Microsoft Excel

Make the most of this lockdown and work-from-home situation, even get your HR to see this as a way of achieving their staff learning and development goals with a reduced…

Continue ReadingFully Online Delivered Business Data Analysis with Microsoft Excel