Redshift dataset Refresh not working

[paulwozniak]

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!

[knov99]

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]

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

[paulwozniak · Accepted solution]

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.

[brett_walton]

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]

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]

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]

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

[v-caliao-msft]

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]

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?