Forum Discussion

Shan968's avatar
Shan968
Frequent Visitor
4 years ago
Solved

Create Excel Pivot based on Power BI datasets

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.

Need Help

3 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    4 years ago

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

     

     

     

    Pat

  • Shan968's avatar
    Shan968
    Frequent Visitor
    4 years ago

    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's avatar
      aj1973
      Community Champion
      4 years ago

      Hi Shan968 

      You need to install 

      You can get it from the service