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

Unable to connect to Amazon Redshift Data Source on PBI Service

Hi,

 

I have created a report by connecting directly to an Amazon Redshift data source (not through an ODBC driver) and am unable to refresh this report on PBI Service, seemingly due to a credentials issue. 

 

When entering in my credentials for my Redshift data source from the dataset settings menu, I recieve the following error message:

Failed to update data source credentials: ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Permission denied (0x0000271D/10013) Is the server running on host "ServerName" (#.#.#.#) and accepting TCP/IP connections on port 5439? Hide details

Activity ID:46b9a97b-eaf7-454a-8035-1c5148ba9481
Request ID:93b5b63b-b78e-dce1-5769-c72257a9ca5e
Status code:400
Time:Mon Apr 29 2019 18:25:20 GMT-0700 (Pacific Daylight Time)
Version:13.0.9264.134
Cluster URI:https://wabi-west-us-redirect.analysis.windows.net

 

I have verified that I can connect to the Redshift source through SQL clients and Power BI Desktop using the same credentials. Ultimately, I'm unable to refresh the report on PBI Service as I cannot seem authenticate credentials, but oddly enough, refreshing works fine on the corresponding PBI Desktop file.

1 REPLY 1
Community Support Team
Community Support Team

Re: Unable to connect to Amazon Redshift Data Source on PBI Service

Hi @tjamal ,

I think this should more related to amazon redshift whitelist, power bi use azure data center to handle data refresh.
So if whitelist is enabled on your datasource, these requests may blocked if you haven't add them to your list.

On-premises data gateway#ports

Power BI security whitepaper

Microsoft Azure Datacenter IP Ranges

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 267 members 2,436 guests
Please welcome our newest community members: