Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Unable to create dataflow using Amazon Redshift

Hi there, 

 

I am running into an issue where I am unable to connect to our Redshift data warehouse when creating a new dataflow. See the screenshot below:

 

Screenshot.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

It seems like this is a defect within PowerBI, as the role field should not be part of the form. Does anyone have any thoughts on a workaround? 

Status: New
Comments
v-lili6-msft
Community Support

hi

try to change the Batch Size to be 1000 instead of NULL to have a test again.

 

Regards,

Lin

dandrews
Regular Visitor

Hi Lin...thank you for the reply. Unfortunately that didn't do the trick, I am still receiving the same error

v-lili6-msft
Community Support

hi

Microsoft account sign-in is a new option we added recently. This requires coordination with Amazon to setup the IAM Role (the value in Role) before it can be used.

 

and also have a look the documents:

 https://aws.amazon.com/blogs/big-data/integrate-power-bi-with-amazon-redshift-for-insights-and-analy...

  https://docs.aws.amazon.com/IAM/latest/UserGuide/reference_identifiers.html

 

Regards,

Lin