Import power pivot table into power bi

[prakash11440278]

Hi Power BI Experts,

I have developed pivot table by using analyze in excel feature in power bi service. I want to publish the pivot table worksheet into power bi. What are the possible ways i can publish and share with end users.

[v-easonf-msft · Accepted solution]

Hi, @prakash11440278 

You can upload your  pivot table to PowerBI Service   "Workbooks", then highlight the cells that you'd like to pin to a dashboard. Select and click the icon, just like pinning a regular report visual, pin data to an existing dashboard or a new dashboard

You can check these documents for more details.

service-excel-workbook-files#local-excel-workbooks 

service-dashboard-pin-tile-from-excel 

By the way, PowerBI doesn't support the data refresh of workbooks, so you may need to reload your pivot table each time you view.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@prakash11440278 , I doubt you can do that. You need to create a pivot in power Bi, if you want to share with end users, via power bi

[prakash11440278]

Hi @amitchandak ,

Thanks for the reply.

How i can create the power pivot in power bi service environment or desktop?

[amitchandak]

@prakash11440278 , What I meant is you can create a pivot table using Matrix.

Or if you need pivoted table do that in power query

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/