Solved: Create Excel Pivot based on Power BI datasets

Shan968 · ‎08-29-2021

Hello All,

Need to udersatnd how can I create a pivot in Excel by using Power BI datasets.

I tried activation Power Pivot in excel but unable to get option of PivotTable from Power BI.

Can you please assist me with this.

Thank you.

aj1973 · ‎08-29-2021

You need to install

You can get it from the service

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Shan968 · ‎08-29-2021

Hi Pat,

Thank you your reply.

I tried this earlier but I am not getting option of from Power BI under data tab.

I have activated power pivot as well.

aj1973 · ‎08-29-2021

You need to install

You can get it from the service

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

mahoneypat · ‎08-29-2021

You should be able to find it here on the Data tab in Excel.

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Create Excel Pivot based on Power BI datasets