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

Invitation: Join UrBizEdge Live Session with Microsoft HQ Excel Team Managers on New Features in Microsoft Excel

Microsoft is doing us a special honor. Three managers from the Excel team at Microsoft HQ are going to be guest presenters at our Dec 6, 2020 live meetup session.…

Continue ReadingInvitation: Join UrBizEdge Live Session with Microsoft HQ Excel Team Managers on New Features in Microsoft Excel

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