web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : TdnPRwvc9Kil6HA+sZLQKw
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Who can explain the di...
Power Apps - Microsoft Dataverse
Unanswered

Who can explain the difference between export to a dynamic worksheet and export to a pivot table?

Like (0) ShareShare
ReportReport
Posted on 16 Sep 2021 00:31:10 by Andrew90771 3

У меня есть таблица, которую я хочу экспортировать в Excel, чтобы сделать в ней панель мониторинга. Мне нужны динамические данные, чтобы я мог выгрузить динамический рабочий лист и динамическую сводную таблицу. Подскажите, пожалуйста, чем они отличаются друг от друга и что лучше для создания дашборда? Заранее спасибо!

Andrew90771_0-1631752101127.png

 

Categories:
Microsoft Dataverse
  • MayankP Profile Picture
    MayankP 462 on 23 Sep 2021 at 13:36:21
    Re: Who can explain the difference between export to a dynamic worksheet and export to a pivot table?

    Hi,

     

    Excel Dynamics worksheet -> https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/basics/export-excel-dynamic-worksheet?view=op-9-1

     

    Excel Pivot Table -> https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/basics/export-excel-pivottable?view=op-9-1

     

     

     

  • Ram Prakash Profile Picture
    Ram Prakash 5,309 Super User 2025 Season 2 on 23 Sep 2021 at 05:53:17
    Re: Who can explain the difference between export to a dynamic worksheet and export to a pivot table?

    Hello @Andrew90771,

     

    Export to Dynamic Work Sheet --> You can have a connect between Excel and Data Verse with realtime

    Export to Pivot --> https://docs.microsoft.com/en-us/powerapps/user/export-excel-pivottable

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Blog : https://microsoftcrmtechie.blogspot.com

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans