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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
paulwozniak
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?
Cluster URI:WABI-WEST-US-redirect.analysis.windows.net
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!

1 ACCEPTED SOLUTION
paulwozniak
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

9 REPLIES 9
knov99
Regular Visitor

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

 

https://powerbi.microsoft.com/en-us/blog/announcing-support-for-amazon-redshift-reports-in-the-power...

 

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

mwitt
Regular Visitor

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

 

 

Malachi Witt | Software Engineer
mwitt@brewer-garrett.com
paulwozniak
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. 

 

thanks 

This solution is hanging.  The Redshift connector was announced here

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-redshift/
https://powerbi.microsoft.com/en-us/blog/building-power-bi-reports-on-top-of-amazon-redshift-data/

 

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

 

These threads have essentially the same issue:

http://community.powerbi.com/t5/Service/Redshift-dataset-Refresh-not-working/m-p/97473#M16455
http://community.powerbi.com/t5/Developer/Redshift-in-Power-Bi-Embedded/m-p/55925#M1763
http://community.powerbi.com/t5/Service/Facing-issue-embedding-redshift-connected-pbix/m-p/83979#M15...
https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-Refresh-from-Amazon-Redshift/...

 

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 PowerBI.com ?

Please share the details, if you have.

 

Thanks,

John

paulwozniak
Helper I
Helper I

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

v-caliao-msft
Microsoft Employee
Microsoft Employee

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.

Reference
https://www.progress.com/blogs/connecting-microsoft-power-bi-to-amazon-redshift
https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-Refresh-from-Amazon-Redshift/...

 

Regards,

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

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors