cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Escalate Topic

WillV
New Contributor II

We use powerBI Server internally - as long as you're appropriately licensed for SQL (Generally SQL server Enterprise with SA) you can use it at no additional cost. 

It's much the same set-up as SSRS  - but here's the thing :  Because there is no native redshift connector on the server edition - we've downloaded the AWS Redshift ODBC connector and we use that instead. - I have to caveat slightly - it works for the limited reports we've created/published, but we'ver really only scratched the surface so far.

 

You will need to install the ODBC driver on your report developer machines(s) as well as your powerBI Server(s).

As it's an ODBC connector - this apprach might even work with SSRS - but I've not tried that .

the driver is available from links here : https://docs.aws.amazon.com/redshift/latest/mgmt/configure-odbc-connection.html 

 

Good luck!