Can I import an Excel Pivot table into Power BI?

[crezzy]

Hi and thanks in advance for any guidance on this.

How can one export a dynamic (I can get static pivot tables) pivot table to Power BI from Excel?

I exported two columns of data, summarized them with Excel to see what I was looking at, using groupings that are difficult to emulate in Power BI. And I'd like to just export the pivot table into Power BI.

Is there a way I can do that? Maybe using Power Pivot or Power Query? Or can I build pivot tables in Power BI? Just a simple export would be the top preference, though.

Thanks again in advance for any help.

 

[crezzy]

Hi and thanks in advance for any guidance on this.

How can one export a dynamic (I can get static pivot tables) pivot table to Power BI from Excel?

I exported two columns of data, summarized them with Excel to see what I was looking at, using groupings that are difficult to emulate in Power BI. And I'd like to just export the pivot table into Power BI.

Is there a way I can do that? Maybe using Power Pivot or Power Query? Or can I build pivot tables in Power BI? Just a simple export would be the top preference, though.

Thanks again in advance for any help.

I should say, *I exported two columns of data FROM Power BI. I'm doing some analytic work in Excel because it's easier, and then rebuilding these tables in Power BI. Rather than using conditionals and bands and all that other fun stuff, if I could just export them instead of building them, it would save some time.

Thanks!