Forum Discussion
Solved
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 ...
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.
Update - as of 3/9/2017 the Power BI service now has the ability to refresh a Redshift data source.