Forum Discussion
redshift refresh
Hi chiragm,
You can take a look at below link which about scheduled refresh from Amazon redshift:
Scheduled Refresh from Amazon Redshift
Regards,
Xiaoxin Sheng
- knov999 years agoRegular Visitor
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#M15037
https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-Refresh-from-Amazon-Redshift/m-p/50587#M4404It'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.