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.
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