Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Excel Source is a collapsed Pivot Table. How do you expand it all??

Hello!

Anyone experienced in extracting data in the query from a collapsed Pivot Table?

Is there some sort of commnad or option?

 

Thanks in advance!

Need Help

1 Reply

  • PattemManohar's avatar
    PattemManohar
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Anonymous  Unfortunately, Power BI will not expand all. You need to do that in Excel itself using "Expand Entire Field" option on the Collapsed Pivot Table and then import.