I'm updating a Power BI report monthly. There is a python script to create a table with connecting couple of tables from amazon redshift, join them, and select few columns from the joined table. I didn't face any problem before but this time I received this error:
DataSource.Error: ADO.NET: Python script error.
<pi>psycopg2.errors.InternalError_: Insufficient system resources to support data size: consider increasing compute size. (Disk Full)
DETAIL:
-----------------------------------------------
error: Insufficient system resources to support data size: consider increasing compute size. (Disk Full)
code: 1016
context: node: 5
query: 102855939
location: fdisk_api.cpp:716
process: query5_40_102855939 [pid=18262]
-----------------------------------------------
</pi>
Details:
DataSourceKind=Python
DataSourcePath=Python
Message=Python script error.
<pi>psycopg2.errors.InternalError_: Insufficient system resources to support data size: consider increasing compute size. (Disk Full)
DETAIL:
-----------------------------------------------
error: Insufficient system resources to support data size: consider increasing compute size. (Disk Full)
code: 1016
context: node: 5
query: 102855939
location: fdisk_api.cpp:716
process: query5_40_102855939 [pid=18262]
-----------------------------------------------
</pi>
ErrorCode=-2147467259
ExceptionType=Microsoft.PowerBI.Scripting.Python.Exceptions.PythonScriptRuntimeException
I cleared cache but it didn't help. Any suggestion?
