Forum Discussion

ncbshiva's avatar
ncbshiva
Icon for Advocate V rankAdvocate V
7 years ago

Online refresh not working with Amazon Redshift views

Hi Team,   I have connected to some Amazon Redshift view with 1.4 Million records. After publishing to the Power BI service , when i click on the Refresh button , it starts the process and throws b...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi ncbshiva

First please check if you could refresh succefully in Power BI Desktop.

Then Go to Dataset->Setting->Refresh setting, Configuring Credentials and Refresh Settings, 

Reference here:

https://powerbi.microsoft.com/en-us/blog/building-power-bi-reports-on-top-of-amazon-redshift-data/

 

If these above doesn't help, 

According to your error message, 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)

 

Besides those, please check outbound ports list that On-premises Gateway supports.

 

Best Regards

Maggie

 

 

ncbshiva's avatar
ncbshiva
Icon for Advocate V rankAdvocate V
7 years ago

HI v-juanli-msft,

 

Thanks for the reply . I am able to refresh the same in the Power BI Desktop. And the credentials have been configured as required.

The refresh seems in Power BI service seems to work when the number of records is less in my imported views.

 

But when the number of records are more like 1.4 billion , i always get this "Timed out exception" error message.

I am not using any gateway to refresh.

 

Regards.