Hi Guys, When i export data from a postgreSQL DB hosted in Amazon Redshift with PowerBi Desktop i got the following error. This error happen for somes tables but not all tables. 1. I coone...
Hi Herbert, Yes I was using the Amazon Redshift (Beta) connector in Apr 2017 version of PBI Desktop. The account has acces to the underliing tables. Method 1, when i use this connector from the "PowerPivot" window it works and *i can import* data from all the tables. Then when i want to edit the query i got an error when the "PowerQuery" window open (see above Error). This error happen for some tables but not all. Some tables are ok and i can edit them. Method 2, when i use this connector from the "PowerQuery" window i got an error (see above Error). This error happen for some tables but not all. Some tables are ok and i can edit then =>So there is a difference between the powerPivot and the PowerQuery window. Finally i found another solution. I can connect to the PostgreSQL database hosted in Amazon by using the postgreSQL connector directly. (even if it is hosted in Amazon). I only need to install the Amazon certificat on my pc first. So wondering what is the best approach to connect to a PostgreSQL database hosted in Amazon. Is it by using the PostgreSQL connector or the Amazon Redshift connector? Hope this help.