Power BI direct connection to Redshift

[fradia]

Hi everybody,

I would like to set up a direct connection between Power BI and a Redshift dataset without using ODBC. I would like to refresh my Reports by connecting directly to the cloud service avoiding the use of an On-Premise Data Gateway.

When I create a Report using Power BI Desktop I can get data from Amazon Redshift without any problems (both in Import and DirectQuery mode). However to refresh the Reports published in Power BI Server I need to set up inbound rules in my Redshift cluster to accept traffic from certain Power BI IP addresses. According to the discussion at the end of this blog post

https://powerbi.microsoft.com/en-us/blog/announcing-support-for-amazon-redshift-reports-in-the-power...

there are two ways to set up the IP adresses:

• configure an Inbound rule for traffic coming from anywhere. This is not very safe though so I would prefer not to use it
• download the list of IP addresses for a given region. Problem: the list is very long and apparently the range could change every week

Is there any other way to achieve this? Maybe an automatic process to define the appropriate inbound rules without having to configure all the IP adresses in the range manually?

Many thanks in advance!

[vinaykumarmamid]

Hi All,

i'm having same issues with connecting Red Shift Data Source using Powe Bi Service.

i can connect to Red Shift in Power Bi Desktop with my credentials 

but when i publish my report into power bi service 

i couldn't connect to data source.

Error Messahe: Unable to connect to red shift data source, In Valid Credentials.

i tried using my team mates accounts as well but no luck.

[v-ljerr-msft]

Hi @fradia,

I would suggest you add this as an idea on Power BI Ideas to improve Power BI on this feature. 

Regards