Scheduled Refresh from Amazon Redshift

[uzmaa]

Hello All,

I created a dashboard using PowerBI Desktop by connecting to Amazon Redshift through ODBC driver. I imported the PowerBI Desktop file into the Power BI online site.

The refreshing data option does not work. When I go to the scheduled refresh option, it states that the datasource contains on-premise data source, although the Redshift is on a cloud & not in premise.

How can I go about to setup a scheduled refresh with Amazon Redshift?

[mschrade]

Update - as of 3/9/2017 the Power BI service now has the ability to refresh a Redshift data source.  

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

[avlad]

so, very interesting - question marked as solved ... where the solution?

[ankitpatira · Accepted solution]

@uzmaa Using odbc driver as source means power bi service is going to look for that odbc driver on-premise when you refresh. It doesn't know other end of your odbc driver is data source in cloud. What you need to use is some form of online data source of power bi such as oData Feed and then publish to service which means when you refresh it is going to refresh from that online source you provide via oData. Here is the article to help you get started on using redshift in power bi.

[knov99]

This solution is out of date.  The Redshift connector is native to powerbi without explicit ODBC or OData. See

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.

[knov99]

This solution is out of date.  The Redshift connector is native to powerbi without explicit ODBC or OData. See

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.

[shrikantp]

Is this complete yet. Do you have auto refresh option working for Redshift connector in powerBI?