Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

dandrews

Unable to create dataflow using Amazon Redshift

Submitted by on ‎06-25-2021 02:16 PM

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
See more ideas labeled with:
3 Comments (3 New)
Comments
v-lili6-msft
Community Support
Community Support
‎06-27-2021 11:28 PM

hi

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

 

Regards,

Lin

dandrews
Regular Visitor
‎06-28-2021 06:26 AM

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
Community Support
‎06-30-2021 12:03 AM

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

Idea Statuses