Unable to create dataflow using Amazon Redshift

[dandrews]

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:

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? 

[v-lili6-msft]

hi

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

Regards,

Lin

[dandrews]

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

[v-lili6-msft]

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