on 01 May 2019 16:07:18
In many of the scenarios while using power BI for Project reporting, we leverage data from Project Workspace. The only way to get data from all project workspace for standard list and template is to use MQuery. We have used this so far but the major limitation using MQuery is, it doesn't get refresh automatically with schedule refresh of Power BI. One has to download the report, open in Power BI Desktop, refresh and then publish.