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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
uzmaa
Frequent Visitor

Scheduled Refresh from Amazon Redshift

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?

1 ACCEPTED SOLUTION
ankitpatira
Community Champion
Community Champion

@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.

View solution in original post

6 REPLIES 6
mschrade
Frequent Visitor

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
New Member

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

ankitpatira
Community Champion
Community Champion

@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.

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.

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.

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.