Auto attendant and Call queue historical reports - Version 3.2 - Error

Hi Heinrich 

Thank you for reaching out to the Microsoft Fabric Community Forum.
 

The issue you're encountering with the fCallQueueAnalytics query is due to the combination of data from multiple sources or references to other queries directly within a step. Power BI enforces strict data privacy and transformation rules, which restrict such combinations unless handled appropriately.
 

In this case, the ChangeTypes step is attempting to apply data type transformations on a source that is derived from another query. Power BI blocks this operation to maintain data privacy or due to query folding limitations.
 
To resolve this, buffer the query before applying any transformation:

BufferedStep = Table.Buffer(PreviousStep),

ChangeTypes = Table.TransformColumnTypes(BufferedStep, {

If buffering doesn't resolve the issue, Navigate to File > Options and settings > Options > Privacy, and either set "Ignore the Privacy Levels and potentially improve performance " or set all data sources to Organizational to prevent privacy-related restrictions.

For more details, please refer to the official Microsoft documentation:

 Privacy levels and data source settings in Power BI.

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank You!