Microsoft’s previewing new Amazon Redshift data connector for Power BI Desktop

News

Reading time icon 2 min. read

Calendar icon Published on

by Radu Tyrsina 

published on

Share this article

Readers help support Windows Report. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help Windows Report sustain the editorial team Read more

Power BI, Microsoft’s suite of business analytics tools to analyze data and share insights is getting a preview of the Amazon Redshift data connector. A new post on the Microsoft Power BI Blog today explains that Amazon Redshift has been one of the most frequently requested data sources from Power BI users over the last year. For now the new connector will only work in Power BY Desktop, with support for Power BI Gateway or PowerBI.com coming in the next couple of months.

The Amazon Redshift data connector will support both Import and DirectQuery connectivity modes in Power BI Desktop. To try it, users will first have to enable the Preview feature by going into File -> Options and Settings -> Options, and then check the Amazon Redshift box under the “Preview Features” tab.

Power BI Amazon Redshift connector
You will have to enable the connector via the Options dialog.

Once it’s done, users will be able to find the connector in the in the “Get Data” dialog under the “Database” tab. After entering credentials, users will be allowed to browse all their databases and tables, load or edit data, create Report visuals and more. You can get more technical details about the new connector on the blog post, and if you try it, we also invite you to share your feedback with the Power BI team via the “Send a Frown” feature.

Radu Tyrsina

Radu Tyrsina Shield

Radu Tyrsina has been a Windows fan ever since he got his first PC, a Pentium III (a monster at that time). For most of the kids of his age, the Internet was an amazing way to play and communicate with others, but he was deeply impressed by the flow of information and how easily you can find anything on the web. Prior to founding Windows Report, this particular curiosity about digital content enabled him to grow a number of sites that helped hundreds of millions reach faster the answer they're looking for.