Forum Discussion

fbottazzoli's avatar
fbottazzoli
Advocate V
6 years ago

PowerBi Pro - Incremental refresh - Time out error at first upload

Hi all I configured incremental refresh on a report based on a transactions table with millions of records for which I want to: - Keep records of the last (full) year  - Refresh data of the last 3...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, fbottazzoli 

 

While the data type of the parameters must be date/time, it's possible to convert them to match the requirements of the datasource. For example, the following Power Query function converts a date/time value to resemble an integer surrogate key of the form yyyymmdd. 

(x as datetime) => Date.Year(x)*10000 + Date.Month(x)*100 + Date.Day(x)

 

Queries can also be limited by the default timeout for the data source. Most relational sources allow overriding timeouts in the M expression. Please consider reducing the size or complexity of your dataset, or consider breaking the dataset into smaller pieces.

 

For further information, you may refer the document .

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • fbottazzoli's avatar
    fbottazzoli
    Advocate V
    6 years ago

    Hi v-alq-msft 

    thank you for your suggestion. However, I don't really understand how it could help me since I was already able to configure the incremental refresh but wasn't able to fix the issue with time out occurring during the very first (massive) data upload. Please note that the time out seems to be due to the data transfer instead than db time out.

    Anyway, I'm now trying to split my database in smaller ones but then I don't understand the advantage of this incremental refresh feature for the pro license. 

    Thank you,

    Francesca