Back

Explore Courses Blog Tutorials Interview Questions

Connecting to private Amazon Redshift from PowerBI service

0 votes
2 views
in BI by (11.1k points)

How can I connect Redshift from PowerBI online service, and redshift is a private subnet not open to internet

1 Answer

0 votes
by (22.5k points)
edited by

Follow the steps:

  1. Install  Windows Server EC2 in the private subnet as the Redshift cluster 
  2. Download  Microsoft On-Premises data on EC2 instance.
  3. Then Install Amazon Redshift ODBC Drivers on EC2
  4. Go to  Power BI service > Manage Gateways, add a new Data Source to the Gateway. 
  5. Publish the report and dataset

Want to learn more about Power Bi, CheckOut: Power Bi tutorial

Related questions

0 votes
1 answer
Connecting PowerBI Cloud to PostgreSQL
asked Jan 24, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
Google big query connecting with PowerBI error
asked Dec 22, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
How to check dataset refresh history for all datasets in PowerBi service
asked Feb 28, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
How to download data from a website daily to use in PowerBI
asked Jan 6, 2021 in BI by Chris (11.1k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...