cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
paulwozniak Helper I
Helper I

Re: Redshift dataset Refresh not working

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
Microsoft v-caliao-msft
Microsoft

Re: Redshift dataset Refresh not working

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

paulwozniak Helper I
Helper I

Re: Redshift dataset Refresh not working

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?

paulwozniak Helper I
Helper I

Re: Redshift dataset Refresh not working

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

paulwozniak Helper I
Helper I

Re: Redshift dataset Refresh not working

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

brett_walton Helper II
Helper II

Re: Redshift dataset Refresh not working

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 

knov99
Regular Visitor

Re: Redshift dataset Refresh not working

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.

 

sibjohn22
New Member

Re: Redshift dataset Refresh not working

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

mwitt
Regular Visitor

Re: Redshift dataset Refresh not working

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

 

 

Malachi Witt | Software Engineer
mwitt@brewer-garrett.com
knov99
Regular Visitor

Re: Redshift dataset Refresh not working

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!

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors