Forum Discussion

AS_0001's avatar
AS_0001
Helper I
6 years ago

Error about Data source credeintials

I'm facing data source credentials errors about datasets of the workspace in power BI services. I published the report to the workspace in Power BI Services. The datasets is AWS and I set credential...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

From Sydney/Australia,

 

Experiencing the same issue, only way to get around this is to open the .pbix file, hit refresh and then publish to workspace.

 

Failed to update data source credentials: 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\ASAzureApp_App1\DataMovementMetadataServicePackage.DataMovementMetadataService.Code.Main_13.0.11747.237_1912180731\ODBC Drivers\RS\AmazonRedshiftODBC_sb64.dll).

 

Activity ID: a360c5d6-71b2-48c5-97e7-d9f7d76e99e8
Request ID: 139f80f6-04e0-7d7f-43c7-083ca3c08272
Status code: 400
Time: Fri Dec 20 2019 09:53:01 GMT+1100 (Australian Eastern Daylight Time)
Service version: 13.0.11747.247
Client version: 1912.2.028
Cluster URI: https://wabi-south-east-asia-redirect.analysis.windows.net/

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous , AS_0001 , gbc_batman , melo-loadsmart , Anonymous , Anonymous 

     

    Unfortunately, Amazon Redshift connector having issues with manual fresh and updating credentials currently. As a workaround, we can install Gateway and configure their Redshift data source to go through it. 

     

    Hi Anonymous , Sorry for that, but we cannot configure a on premise gateway on an Apple machine

     

    Apology again for the inconvenience caused by this issue.


    Best regards,

     

    • AS_0001's avatar
      AS_0001
      Helper I
      6 years ago

      v-lid-msft 

       

      Thank you for your workaround.

      Unfortunately our environment cannot set onpremise data gateway. Is there any workaround? If we configure ODBC in AWS, does it work?  I hope Microsoft resolve this issue as soon as possible.

      It was really heavy workload to download many PBIX files and refresh and publish it every day.

       

    • gbc_batman's avatar
      gbc_batman
      Frequent Visitor
      6 years ago

      Today it started working again, the credentials error was fixed. It looks like it is an itermittent issue.

      Thanks

      • AS_0001's avatar
        AS_0001
        Helper I
        6 years ago

        Microsoft support desk sent the email to us that the issue was resolved thanks to update Dec.18 and 19. We confirmed the issue was resolved.