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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I

Redshift dataset Refresh not working

When I try to refresh a Redshift dataset in the service I get the following error:


Data source type: 
Processing error:The import AmazonRedshift.Database matches no exports. Did you miss a module reference?
Activity ID:c7178d9c-2103-4b07-a2cd-dddb08eeaf94
Request ID:217ba50f-7dea-a338-f5da-a03c5fd43b5c
Time:2016-12-02 20:10:48Z


My Redshift instance has locked down access such that only certain IP addresses are allowed to connect to it. I looked, but couldn't find a list of Power BI Service specific addresses to allow. I did find the Azure IP addresses but that seems like I'd be opening up the Redshift instance to all Azure traffic.


Does anyone have any advice about refreshing a Redshift dataset that does not involve opening up the instance completely?


It may also be possible that the error above has noting to do with that, I just assumed so.


Any advice is highly appreciated!

Helper I
Helper I

I've not been able to get the Redshift connector to refresh in the Power BI service. I've gone back to the ODBC connector and that works.

View solution in original post

Regular Visitor

I see that Redshift is now supported for refresh in the Power BI Service:


I can confirm that it works on my database.  Great!

Regular Visitor

Any updates on when the auto refresh for RedShift will be fixed?



Malachi Witt | Software Engineer
Helper I
Helper I

I've not been able to get the Redshift connector to refresh in the Power BI service. I've gone back to the ODBC connector and that works.

Guys I do NOT believe MS has delivered the ability to refresh from the BI Service from Redshift.  They only currently offer it (in Preview) for the desktop application. My last contact with someone on the PBI support side said end of 2016 but I have not seen this. Do you have a different understanding. 



This solution is hanging.  The Redshift connector was announced here


This last article, dated Aug 1 2016, said the Redshift connector doesn't yet work for "Power BI Gateway or for refresh scenarios, which will come in the next couple of months."


These threads have essentially the same issue:


It's been six months since "a couple of months" was promised. Any news? This is a big issue for my application, where I need to do scheduled refreshing in the PBI service, just like any other database.


Hello All,


Any update on RedShift Connector for Power BI is supporting  Power BI Gateway or ?

Please share the details, if you have.




Helper I
Helper I

Is any one able to refresh their Redshift data set in Power Bi Service using the Redshift beta connector?


Hi @paulwozniak,


How do you connect to Amazon Redshift database, with ODBC or Odata?


In order to enable refresh your dataset in Power BI services, you need to connect to Amazon Redshift with OData. OData is a standardized protocol for creating and consuming data APIs. In other words, it’s a standard for providing access to data over the Internet in real-time.




Charlie Liao

I'm connecting using the Amazon Redshift data source which is in beta right now. Are you saying that this dedicated data source will not work with the refresh in the Power BI service?

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors