Forum Discussion
Amazon RedShift error with published reports.
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????
2 Replies
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.⚡
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 CloudYou 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-onpremBest 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.
