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

Connection to Redshift after publish Power BI workbook

Hi all, 

I have dashboards/workbooks in Power BI Desktop which having Redshift as data source. The connection is working fine on Power BI Desktop. But when I publish it to the web server, the Redshift connction has lost, which asking me whether Redshift is accepting tcp/ip address on port 5439?(Find attached)

 

Any suggestions on how to solve this? Thank you.error.PNG

4 REPLIES 4
Community Support
Community Support

Re: Connection to Redshift after publish Power BI workbook

HI @Karho,

 

According to your error message and snapshot, I think this issue should related to redshift white list.

 

I'd like to suggest you to check your amazon redshift rules to allow power bi service and gateway request can connect to that datasource.

Microsoft Azure Datacenter IP Ranges

Creating and Configuring a Web Access Control List (Web ACL)

 

Regards,

Xiaoxin Sheng

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

Re: Connection to Redshift after publish Power BI workbook

Hi Sheng,

 

If Redshift need to whitelist Power BI, it would need information like IP address to whitelist. However, when we publish Power BI workbook it means that we publish it to the cloud, which has no IP address. What information and how we can provide from Power BI for Redshift for the whitelisting?

 

Thank you,

Kar Ho

Community Support
Community Support

Re: Connection to Redshift after publish Power BI workbook

Hi @Karho,

 

I already share them above, you can download Microsoft Azure Datacenter IP Ranges file to review related data service ip range. But it seems quite large so you can't fully add them to your whitelist. Please choose related ip address which neasted to your datasource hosted.

 

Regards,
Xiaoxin Sheng

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

Re: Connection to Redshift after publish Power BI workbook

@v-shex-msft which sections from the lengthy Azure IP JSON files should be whitelisted.  In other words, do the connections come from the Storage IPs, the AzureCloud IPs, something else?

 

Thanks!

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.