Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We've got a few Direct Query reports pointing at a Redshift cluster. This has worked great the last few weeks but over the last two or three days, we're getting schema load errors when attempting to render these reports.
When we attempt to refresh the data, we're seeing that there's an issue loading the Redshift ODBC driver (see below).
@Microsoft - Is this a known issue? Is it possibly related to a recent PBI release?
At this point, we're dead in the water with these reports and really need this to be working again.
Here's the detailed error:
Something went wrong There was an error when processing the data in the dataset. Please try again later or contact support. If you contact support, please provide these details. Data source error: 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_App5741\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. Table: opp_dim_npi. Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net Activity ID: 1111043c-4262-4aaa-a740-5b19114b17ba Request ID: c88b2953-366e-81db-61ce-35cedefa04ce Time: 2018-12-03 03:45:19Z
- Terence
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.