'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Is Microsoft Planner Task History Available in Dataverse for Power BI?
Question details
The user is trying to determine if comprehensive Microsoft Planner task history is accessible through Dataverse for reporting in Power BI.
- Product
- Microsoft Power BI
- Device & OS
- not provided
- Scenario
- Connecting Microsoft Planner data to Power BI via Dynamics and Dataverse to build task history reports.
- Observed behavior
- The Project History table in Power BI appears incomplete or unavailable, and does not display all the required Planner task history information.
Ensure you have the appropriate administrative permissions in Microsoft Power Platform and that your Power BI Desktop is updated to the latest version.
Consult Official Documentation and Community Resources
Because this issue involves complex Dataverse connectivity and specialized Power BI data models, you must verify supported fields in Microsoft's documentation and consult experts.
Microsoft Dataverse does not always expose every backend historical field by default. The availability of Planner and Project task history depends on the specific Microsoft 365 licensing and the schema definitions currently supported by Microsoft.
Search for and open the official Microsoft documentation titled 'Project for the web Task History Definition'. Review this document carefully to identify which specific records, tables, and fields are officially supported and available for extraction.
Open Power BI Desktop, click on 'Get Data', and select 'Dataverse'. Connect to your environment and use the search bar in the Navigator window to search for 'Project History' or 'Task History' to see exactly which tables are exposed to your account.
If the required tables remain missing or incomplete, navigate to the official Microsoft Power BI Community forums. Create a detailed post explaining your Dataverse setup and ask for specialized guidance on retrieving Planner task history.
Analyze Exported Planner Data Easily with WPS Office
While WPS Office does not directly manage complex Power BI or Dataverse API connections, it is the perfect lightweight alternative for analyzing exported data. If you need to export your Microsoft Planner tasks to an Excel spreadsheet for quick reporting, WPS Spreadsheets handles it seamlessly without the heavy subscription costs of Microsoft 365.
- 1. Download and Install: Visit the official WPS website to download the free installation package for your operating system.
- 2. Export Planner Data: In Microsoft Planner, click the three dots (...) at the top of your plan and select 'Export plan to Excel'.
- 3. Open with WPS Spreadsheets: Launch WPS Office and open your newly exported Excel file to begin building your task history reports and charts immediately.
Frequently Asked Questions
Why is my Planner task history missing in Power BI?
Task history might be missing because the Dataverse connector does not automatically expose all historical tracking fields, or your current environment permissions restrict access to the comprehensive Project History tables.
Can I export Microsoft Planner tasks directly to Excel instead of using Power BI?
Yes. You can export your tasks by opening your plan in Planner on the web, clicking the three dots (...) in the top menu, and selecting 'Export plan to Excel'. This creates a spreadsheet containing all current task details.
Does WPS Office support files exported from Microsoft Planner?
Yes. Microsoft Planner exports data in standard Excel (.xlsx) format, which is fully supported and seamlessly opens in WPS Spreadsheets for immediate data analysis and reporting.
