Unable to connect VIEW to Amazon Redshift

[SwatiP]

Hi,

I am also unable to connect VIEW to Amazon Redshift. Anyone can please assist on the issue.

[v-shex-msft]

HI @SwatiP,

Which view you means? Can you please provide more detailed information?

For connect to amazon redshift you can refer to below link:
Connect to Amazon Redshift in Power BI Desktop

Regards,

Xiaoxin Sheng

[SwatiP]

Thanks for your reply.

I am taking about the VIEW that we create in any database instead of table. Power Bi is able to connect with table but while i am trying to connect with VIEW that is derived from another table, then the VIEW is not recognised from power BI. Is there any driver issue or is there any other way to connect?

[v-shex-msft]

Hi @SwatiP,

I think it just mean power bi desktop amazon redshift connector not support to load view.
Maybe you can try to mapping your view as table, then try to get data from this new table.

Regards,

Xiaoxin Sheng