Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

The result of query is too large.

Please, help me about the problem of "The result of query is too large", below the messenger error:

 

ID da atividade: 453b8598-55c6-485a-aab4-f167fe945446
Solicitar ID: 9ed588a7-eba5-ef60-606c-5f2641f2b5f3
ID de correlação: f48f3b0f-a9e5-4d9c-fb69-7cb3a9f8c747
Hora: Mon Jan 20 2020 09:37:38 GMT-0300 (Horário Padrão de Brasília)
Versão do serviço: 13.0.11888.316
Versão do Cliente: 1912.4.031
Cluster URI: https://wabi-brazil-south-redirect.analysis.windows.net/

 

Best Regards

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Jonathanstos

 

Does the issue happen when you refresh the dataset or open the report? 

 

From internal trace, I found the error message "Failure encountered while executing the DAX query". I would suggest you download the report and open it in Power BI desktop, check if there is any issue with measure or calculated column/table. 

 

Best Regards,
Qiuyun Yu

Jonathanstos
New Member

Hi @v-qiuyu-msft 

 

Thank's for sugestion, but the issue happen when I open the report, in power BI Desktop the report is "OK", but when open the report at power BI Service happen the problem.

v-qiuyu-msft
Community Support

Hi @Jonathanstos

 

Which data sources does the report get data from? Which connection mode do you use, import, DirectQuery or Connect Live? 

 

When you open the report in Power BI desktop, then click on Refresh button, check if any issue occurs. 

 

Best Regards,
Qiuyun Yu