Ok, here is an excellent solution.
– open the pivot table
– put a measure
– double click a number in the PivotTable
– you get a new worksheet with the details of the measure you double-clicked
– right-click any cell of the table you see and click “Edit Query…”
– replace the query content with
EVALUATE <tablename>
where <tablename> is the name of a table.
You will get the entire content of the table back.
You can use any valid DAX table expression, there.
You can create DAX queries using DAX Studio.
Paste the code there, you have your data in a flat table – and it is amazingly fast!
https://www.youtube.com/watch?v=3fAE_qQCxZg
Ref: https://community.powerbi.com/t5/Service/Connect-to-dataset-from-Excel-as-a-TABLE-not-PIVOT/m-p/1424056#M110858