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