Forum Discussion

paulwozniak's avatar
paulwozniak
Helper I
9 years ago
Solved

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 mis...
Need Help
  • paulwozniak's avatar
    paulwozniak
    9 years ago

    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.

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

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/td-p/50158

 

Regards,

Charlie Liao

paulwozniak's avatar
paulwozniak
Helper I
9 years ago

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?