autorefresh error

(1) Share

Report

Posted on by CU17091930-0

There are several prepared reports on the Power bi report server. Each of these reports is connected to auto refresh. There is 1 report that gives an error during auto refresh and does not refresh. This report is a sales report. In this report, the dataset consists of 77768 row views and 2 excel tables and several calculated tables. During autorefresh, it shows the following error

Memeor error: Memory allocation failure. Try simplifying or reducing the number of queries
The command has been canceled. The exception was raised by the DataReader interface. Please review the error message and provider documentation for information

Reports with a larger volume than this report do not give errors during autorefresh and are refreshed without errors. I can't find the reason for the problem in the sales report. Could you please help me. I can mention any additional information you need.

All responses (1)

Answers (0)

Sami Ullah 284 on at

Like (0)

Report

autorefresh error

Hi,
The error you’re seeing during the auto-refresh on Power BI Report Server is probably due to the complexity of the queries or memory limits on the server, especially for the dataset being used. By the way, can you let me know which data source you're working with?