Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am using the Amazon Redshift connector in Power BI. While I am able to connect to tables, I am not able to connect to views. I receieve the following error message:
DataSource.Error: The table has no visible columns and cannot be queried.
I have not had any difficulty connecting to this view using other client software. Likewise, I have not had any difficulty connecting Power BI to views on other database systems (such as Oracle). This seems to be a limitation in Power BI's connection to Amazon Redshift. In general I expect to be able to connect to a view the same way I connect to a table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.