cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AS_0001 Frequent Visitor
Frequent Visitor

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?

 

23 REPLIES 23
Community Support Team
Community Support Team

Re: Error about Data source credeintials

Hi @AS_0001 ,

 

Sorry for that, We cannot reproduce the issue here and also not found an effective solution.

 

(Update reply with reproduce screenshot)

 

21.PNG22.PNG

 

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/

 

Support Ticket .gif

 


Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AS_0001 Frequent Visitor
Frequent Visitor

Re: Error about Data source credeintials

@v-lid-msft 

 

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.

Community Support Team
Community Support Team

Re: Error about Data source credeintials

Hi @AS_0001 ,

 

Have you tried use on-premises data gateway to connect the Amazon Redshift ?


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AS_0001 Frequent Visitor
Frequent Visitor

Re: Error about Data source credeintials

@v-lid-msft 

 

No, we have not tried to utilize on-premise gateway.

 

Regards,

Matthijs1 Frequent Visitor
Frequent Visitor

Re: Error about Data source credeintials

I'm having the same issue. Is there a fix or solution for this issue now?

AS_0001 Frequent Visitor
Frequent Visitor

Re: Error about Data source credeintials

@Matthijs1 

Hello, we have not received resolution way from Microsoft yet. I heard Microsoft is continueing to investigate.

Matthijs1 Frequent Visitor
Frequent Visitor

Re: Error about Data source credeintials

@AS_0001 

Thanks. If you hear anything please let me know. Did you find a solution for now or do you manually update?

AS_0001 Frequent Visitor
Frequent Visitor

Re: Error about Data source credeintials

@Matthijs1 

Sure. I will keep it posted.

Currently we need to download PBIX from PBI service, reflesh data in PBI Desktop and then publish it to PBI Service as a manual process.

AS_0001 Frequent Visitor
Frequent Visitor

Re: Error about Data source credeintials

Let me confirm one thing.

Which region is your location? Our Power BI location is Japan region. Microsoft told that the error happens in specific region.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)