Forum Discussion
Your data source cant be refreshed because the credentials are invalid. works fine with SQL Workbnch
I am connecting to a Redshift database. I can connect with my same creds using SQL Workbench and within PowerBI Desktop. But cannot refresh dataset through service. It says creds invalid in the Setti...
Hi Anonymous
You would need a gateway to connect to your Redshift database. The only cloud supported databases are Azure and Snowflake, all others would need a gateway.
Here is an example with an Oracle database but the same steps could be followed for Redshift
Manage your data source - Oracle - Power BI | Microsoft Docs
And here is how to install and configure the ODBC connection: Using Azure Analysis Services to connect via an ODBC Source (Redshift) - Reporting/Analytics Made easy with FourMoo and Power BI
