Conversion of Pivot table to normal table

[akarna772]

I have excel 365 workbook which I got after clicking analyze in excel from published data in power bi. I have pivot table in the workbook where I filled the values by selecting the fields. Data is linked to pivot table. Can I change it into normal table or generate normal table from pivot table? If it is possible, will data get refreshed in that normal table like pivot tables.

[lbendlin · Accepted solution]

No need for any of this.  Run a DAX query against the dataset and put the results in a table.