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: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! 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