Forum Discussion
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 credentials for schedule maintenance.
Current error message in Datasource credentials is below.
"Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again."
When I clicked "Edit credentials" and then fill in ID and password but faced the following error message.
----error message----
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.11499.217_1911240307\ODBC Drivers\RS\AmazonRedshiftODBC_sb64.dll).
Activity ID: 2d1d06b7-d347-4bcb-bed4-18cf046af18c
Request ID: fb723fd6-20cd-a51d-c129-bcd97ed2897d
Status code: 400
Time: Mon Nov 25 2019 13:53:21 GMT+0900 (Japan Standard Time)
Service version: 13.0.11499.187
Client version: 1911.3.022
Cluster URI: https://wabi-japan-east-redirect.analysis.windows.net/
------------
I've already cleared chashe of the browser and the sign-in PBI service again, however situation is same. On the Power BI desktp, we can connect to same datasets with the ID and password.
Could you support to resolve the issue?
25 Replies
Hi AS_0001 ,
Sorry for that, We cannot reproduce the issue here and also not found an effective solution.
(Update reply with reproduce screenshot)
We suggest you to delete the ID information in your origin post and then open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/
Best regards,I'm sorry to hear that you cannot reproduce it.
It seems it's not our project only. I've already contacted Microsoft support team directly and wait their update.
I hope the issue will resolve soon.
Hi AS_0001 ,
Have you tried use on-premises data gateway to connect the Amazon Redshift ?
Best regards,
Same error here in region: North Central US (Illinois)
It was working fine until last friday (13/Dec/2019), from Saturday onwards all of my datasets in Power BI services started to give errors when refreshing.
Remarks:
-My data source is Redshift;
-In PowerBI desktop it refreshes with no error;
Thanks
Hi,
Just tried to refresh again now and it is working fine. It looks like it was something temporary that they were changing on the cloud.
Best Regards
Me too 😞
Today the error has returned after I updated one of my reports and published it again.
This time I can refresh it on Power BI service, but when I try to schedule it, it tells that I need to fix the credentials and that's when the error pop up:
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_1912180246\ODBC Drivers\RS\AmazonRedshiftODBC_sb64.dllFrom 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/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,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.
