Report service return Error when refreshing with incremantl refresh
Yes, I have a Power BI premium license and the very same report was working until friday. My data source is Redshift.
And yes, it was failing when i tried to refresh report in Power BI Service with enabled incremental refresh option. However, it now fails also when incremental refresh is off.
The error i'm getting now is different from yesterday's. this is what i'm getting now
ODBC: ERROR [IM003] Specified driver could not be loaded due to system error 126: The specified module could not be found. (Simba Amazon Redshift ODBC Driver, D:\SvcFab\_App\analysisserver.backendapptype_App12480\analysisserver.backend.servicepackage.Code.2018.11.4.37\workloads\AS.2018.11.4.204\MDataEngine\ODBC Drivers\Simba Amazon Redshift ODBC Driver\AmazonRedshiftODBC_sb64.dll).. The exception was raised by the IDbCommand interface.
It seems there is a problem with Redshift (see here https://community.powerbi.com/t5/Service/Direct-Query-connectivity-issues-with-Redshift-in-the-last-few/m-p/576983/highlight/true)