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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Dataflows - Redshift Connector - "An exception occurred: 'ProviderName' is not a valid Amazon"...

Hi everyone!
Since yesterday we are having troubles to build up Dataflows from scratch.

If we want to create a new Dataflow connecting to Redshift, we have to re-use Dataflows because we get this message:

 

An exception occurred: 'ProviderName' is not a valid Amazon Redshift option. Valid options are: 'BatchSize, Role' (Session ID: *********************************, Region: europe)

 

agarciagarcia_1-1645031312136.png

 

Maybe the Redshift Connector is broken: It seems that it is sending 'ProviderName' instead 'BatchSize' or 'Role'.

Anyway, already created Dataflows are working, and we can create new ones just using another .json dataflow configuration, or just hard coding the queries without using the connector.

Have been changes recently made to the connector? 

 

Thanks in advance! Cheers!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Connector has been updated and now is working fine. Thanks all!

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Connector has been updated and now is working fine. Thanks all!

I am having this same issue, how do you update the connector? Were you able to get it updated in the gateway machine?

v-yalanwu-msft
Community Support
Community Support

Hi, @Anonymous

What happens if you try and use an ODBC connection instead of the Amazon Redshift option and see if that works?

 

You can use the blog post here to show how to configure the ODBC connection: Using Azure Analysis Services to connect via an ODBC Source (Redshift) - Reporting/Analytics Made ea...

 
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi @v-yalanwu-msft , thank you for your response.

First of all, the connector is still failing when trying to build new DataFlows, but its working fine with already created ones. 

We have not access to the GateWay machine, so we cannot install the redshift driver -> we cannot use the ODBC connector with Redshift.

Anyway, from my point of view, using ODBC connector while having an official connector that we use everyday(Redshift) that is kind of broken is not a valid solution. 

I really don´t know yet if anything changed in the official Redshift connector, but seems so. Any clue?

Regards.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors