Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
akarna772
Frequent Visitor

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.

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.