Amazon RedShift error with published reports.

[amtrakrob]

Hello all.
I have a report that pulls data from Amazon Redshift.  My PowerBI desktop connects to the data source with not problem  I can pull in data, and create the report.
But...I publish the report.   It looks like it published ok, but when I go in the report I get 

I've made all the changes I could with the Authentication Method, and Privacy level.. I constantly get the same error.

Any ideas????

[v-easonf-msft]

Hi, @amtrakrob 

As mentioned by @parry2k ,although Amazon Redshift is a cloud service, it is recommended to install On-premises data gateway to keep your reports up to date.

You can  refer  to  this AWS white paper for more information.
Using Microsoft Power BI with the AWS Cloud 

You can check the link below for the latest version of standard On-premises data gateway.
download On-premises data gateway. 

More information about gateway, please refer to this llink.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@amtrakrob I believe you need an on-premises data gateway to make it work.

Integrate Power BI with Amazon Redshift for insights and analytics | AWS Big Data Blog

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡