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

[Heinrich]

Hello
I wanted to update the "Auto attendant and Call queue historical reports" to 3.2 but it throws an error.

fCallQueueAnalytics

Query 'fCallQueueAnalytics' (step 'ChangeTypes') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

Do you have an idea.
Regards
JFM_12

[Lucky49]

Thanks this helped resolve my issue with multiple queries being blocked...

[Heinrich]

Hello @v-karpurapud 
Thank you very much.
I did implement it and it worked.
Have a great day
JFM_12

[v-karpurapud · Accepted solution]

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!