L
Legacy 452786
Guest
Hi,
With regular pivot tables it's possible to increase the double-click data drill-down too >1000 rows by clicking Data->Queries and connections->Right click on ThisWorkbookDataModel->Properties->and increasing the "maximum number of records to retrieve" under "OLAP drill-though".
However if the data model is created with Powerquery, this seems to be disabled.
ThisWorkbookDataModel is not found under Queries and Connections. And right clicking on any of the queries shows this the feature as grayed out.
Ideas?
With regular pivot tables it's possible to increase the double-click data drill-down too >1000 rows by clicking Data->Queries and connections->Right click on ThisWorkbookDataModel->Properties->and increasing the "maximum number of records to retrieve" under "OLAP drill-though".
However if the data model is created with Powerquery, this seems to be disabled.
ThisWorkbookDataModel is not found under Queries and Connections. And right clicking on any of the queries shows this the feature as grayed out.
Ideas?
