Forum Discussion

icassiem's avatar
icassiem
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

PowerBI Service connect to AWS Redshift Serverless directly and not via On-Prem Gateway on EC2

Good day,   I have sources from ERP/CRM salesforce/NetSuite directly to powerbi services I have product data within AWS Redshift and am setting up an EC2 instance to configure the On-Prem Gateway ...
Need Help
amustafa's avatar
amustafa
Icon for Solution Sage rankSolution Sage
2 years ago

On a second thought...you can always set a cron job on AWS to extract summarized data from your Redshift and put it in S3 in parquet or csv format. Microsoft Fabric Lakehouse can now create a shortcut to S3 seamlessly. This will save you time and money. 

 

You can also try to use the Postgress connection from Power to Redhsift and it works too.

icassiem's avatar
icassiem
Icon for Post Prodigy rankPost Prodigy
2 years ago

The "Postgresql or Redshift connection from Power to Redhsift" will work with a VPC endpoint for external access correct?

Anything PBI/Redshift/AWS require when selecting the postgresql/redshift connection source in service/desktop other than the redshift credentials?

connection string is redshift url?

 

Apologies, not to clued up on AWS either, will be testing this next week