0 Kudos

Dataflow redshift started failing

Status: Needs Info
by cstepszen Visitor on ‎02-07-2019 01:09 PM

We encountered an error during evaluation. Details: DataSource.Error: ODBC: ERROR [IM003] Specified driver could not be loaded due to system error 5: Access is denied. (Simba Amazon Redshift ODBC Driver, C:\app\ODBC Drivers\Redshift\AmazonRedshiftODBC_sb64.dll).

Status: Needs Info
Comments
by Moderator v-yuezhe-msft
on ‎02-12-2019 12:29 AM

@cstepszen,

It seems that there are some issues with the Simba Amazon Redshift ODBC driver, please follow the guide in this article to verify the installation and configuration of the driver.

Regards,
Lydia

by Moderator v-yuezhe-msft
on ‎02-12-2019 12:29 AM
Status changed to: Needs Info
 
by cstepszen Visitor
on ‎02-12-2019 07:14 AM

How can I install the driver or configure the driver on the PowerBI Service (Dataflow)

by Moderator v-yuezhe-msft
Friday

@cstepszen ,

Do you connect to Amazon Redshift through ODBC connector? If so, please install and configure the driver in the machine that hosts gateway.

Regards,
Lydia