SakshiWalia_06's avatar
SakshiWalia_06
Frequent Visitor
2 years ago
Status:
Done

Redshift Connector not working in Power BI Report Builder

Native Redshift connector is not working in Power BI Report Builder. It works only with Power BI desktop.

Can you confirm if there are any pre-requistes.

 

 

 
 

 

2 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi  SakshiWalia_06 ,

    Using the native Redshift connector in Power BI Report Builder can be a bit tricky since it’s not fully supported. However, you can still connect to Amazon Redshift by following these steps:

    You may install the Amazon Redshift ODBC Driver and configure the ODBC Data Source:
    Add a new data source and select the Amazon Redshift ODBC driver.Configure the connection settings, including the server name, database name, user ID, and password. and finally create a Data Source in Power BI Report Builder.

     

    For more you may refer to :aws.amazon.com

     

    Best regards.
    Community Support Team_Caitlyn