Scheduled Refresh timeout and incremental refresh confusion!

Question

Hi,

I am still very new to PBI and don't have much prior complex computational experience. I have set up a basic report which reads from an SQL database. My report currently holds around 8 million rows of data and I have been trying to set up an incremental refresh. I would estimate there are about 1,000-10,000 new rows each week. Currently all looks well in the desktop report with the correct parameters created, however when I view the dataset on the online service, the parameters don't appear.

I thus tried to set up a basic scheduled refresh across the whole dataset but get the following error:

An error occurred while processing the data in the dataset.
Refresh failed:

WQ_Plotting_Tool_Refresh_Trial has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
{"error":{"code":"DM_GWPipeline_Gateway_TimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_TimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}}

Am I right in thinking this is because the dataset is too large and the refresh times out? If so, I would imagine I need to use 'incremental refresh' thus the second question is what is the likely reason my parameters are not appearing in the service?

The incremental refresh box on the desktop gives the following message, is it the 'M Query' error which means this will not work? From what I have read SQL servers shouldn't have any issue with Incremental Refresh?

Answer 1

@uttonOliver-6333 Thank you for reaching out.
Please note that Power BI is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products.

For questions more related to Power Bi, you may ask the experts in the dedicated Power BI forum over here:
https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums