Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Conversion of Pivot table to normal table

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.

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

1 Reply

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