I use a lot of raw data to build reports in Power BI, however I am running into an issue with larger M365 Tenants where my base metric: "Users[?userType!=
Guest
]" returns the error: 'Metric failed to evaluate. Please update this metric to have a valid query.'. I have been informed by support to try to decrease the results from my query, which using filters defeats the point and attempting to only return needed columns results in: 'data.Queries[0].Query should NOT be longer than 1000 characters'.
I would like for either metrics to return everything or for there to be some way to use the Power BI integration to pull the full Data Print.