Connecting Power BI to Provisioned Redshift Cluster - Inbound Rule?

0

Hi,

I am trying to establish a connection between my desktop version of Power BI and my Provisioned Redshift cluster in the London Region but I receive a timeout error.

My cluster is publicly accessible and I have been able to overcome the error temporarily by creating an inbound security group rule rule for all traffic. However, as the recommended action is to only allow access from known IP addresses, I was wondering if there is a specific IP address for Power BI in the UK? Or, is there another way that I should be establishing the connection to Power BI?

Thanks

GoData
質問済み 4ヶ月前201ビュー
2回答
1
承認された回答

Generally when you are using PowerBI Desktop, it will be the IP Address of your location. You can find your IP (https://whatismyipaddress.com/) address from here and you can allow that on the security group on AWS.

AWS
Phani_L
回答済み 4ヶ月前
profile picture
エキスパート
レビュー済み 9日前
profile pictureAWS
エキスパート
レビュー済み 4ヶ月前
0

Hi, from the Security best practices perspective, it is not recommended to expose to the public your databases. This is a general rule applies also for your Amazon Redshift Cluster. Therefore I would recomand to setup a Microsoft on-premises data gateway to enable Power BI to communicate with data stores that are not accessible from the public internet. Than you can keep your Amazon Redshift Cluster inside a private subnet without exposing externally your databases. For that end please follow the go-through here : https://aws.amazon.com/blogs/big-data/integrate-power-bi-with-amazon-redshift-for-insights-and-analytics/ Enter image description here

profile pictureAWS
Semir
回答済み 4ヶ月前
profile picture
エキスパート
レビュー済み 2ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ