Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

0
ashwanth_pasu

Unable to Publish a report in Power BI Service while connected via Redshift Direct Query

Submitted by on ‎05-10-2017 09:06 PM

I can connect to redshift with desktop but not via the service. When I publish the report to the service, it asks me to give the credentials for redshift, but when i do that I get this following error everytime

 

 

 

"The credentials you provided for the data source are invalid. Please check the credentials for all the data sources

 

How can I sort this out?

Activity ID:5095b88e-1487-4abb-9428-6f090e751768
Request ID:0e06c0c0-b0ca-0df8-05c5-7f9c086fafed
Status code:400
Time:Wed May 10 2017 17:10:57 GMT+0530 (India Standard Time)
Version:13.0.1700.2027
Cluster URI:https://wabi-us-east2-redirect.analysis.windows.net
Status: Delivered
See more ideas labeled with:
7 Comments (7 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎05-15-2017 12:01 AM

@ashwanth_pasu

 

Does the hostname match the certificate? If not, you need to use the hostname that matches the certificate.

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎05-15-2017 12:02 AM
Status changed to: Needs Info
 
ashwanth_pasu
Frequent Visitor
‎05-15-2017 09:23 PM

It says the data source for my credentials is invalid. You can see the below image, I try to login with my master username and password which works well for all my other redshift connections.

 

The other two options extension Datasourcekind and path cannot be edited. The path is same as the one in my cluster. i dont know why I am getting this error

red1.png

ashwanth_pasu
Frequent Visitor
‎05-15-2017 10:38 PM

I am not able to publish a Power BI Report created via Amazon Redshift Direct Query to Service. It says my data source credentials are invalid.

 

I use the same Redshift credentials that I use for all my other connections. The datasource path shown in the power BI service is also right.

 

this is the error I am getting. The datasource path and the name in that image shown cannot be edited as well. We can only enter the username and the pwd. i used my cluster's master username and password for the same and it did not work.

 

I dont know why I am getting this error? Did anyone face the same issue if so how did you solve it? 

 

The credentials you provided for the data source are invalid. Please check the credentials for all the data sources.Hide details

Activity ID:2a8773e5-ddf6-4c5b-bb9b-1c6a5813c900
Request ID:71c8bde3-9b98-a06b-9b9f-e49c88937f09
Status code:400
Time:Tue May 16 2017 11:05:17 GMT+0530 (India Standard Time)
Version:13.0.1700.2143
Cluster URI:https://wabi-us-east2-redirect.analysis.windows.net

 

red1.png

v-haibl-msft
Microsoft Employee
Microsoft Employee
‎05-16-2017 07:05 PM

@ashwanth_pasu

 

I suggest you to create a support ticket at http://support.powerbi.com (see bottom of page).
If issue is resolved, you can share the solution here later to help others who have the same problem.

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎05-25-2017 06:35 PM
Status changed to: Delivered
 
blhp68
Regular Visitor
‎08-07-2017 09:12 AM

Curious if this issue was ever addressed?  I am having the same problem

 

My Error message:

The credentials you provided for the data source are invalid. Please check the credentials for all the data sources.Hide details

Activity ID:90ff17d9-e70f-4429-a0cb-62f507355d0e
Request ID:0832c5eb-a8ed-cceb-f409-3067e3612218
Status code:400
Time:Tue Aug 08 2017 09:32:27 GMT-0500 (Central Daylight Time)
Version:13.0.2025.193
Cluster URI:https://wabi-us-north-central-redirect.analysis.windows.net

 

Idea Statuses