History export

Gongi1625 Here is another option, if you can publish your data to a Power BI Premium Workspace and have Power Automate.  In the workspace, create a paginated report and using Power Automate write the require data (fields) to a file, or directly to a dataverse table.  The flow can be scheduled to run on daily, weekly, etc., or as needed.  You would then pull this data into your Power BI model and assign the appropriate relationships.  You would also need to establish some processes to validate the stored data as projects and tasks may get deleted over time and you need to determine how you want to handle those situations.