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 ...
Hey davidbrown100,
I doubt Microsoft will address this issue anytime soon - here are workarounds.
My solution - right now I am moving data into a "datawarehouse" schema to manage the table import process - using Fishtown Analytics dbt tool as an ETL tool. And it works well after installing it - basically is a select into type ETL to summarize my data before import.
Quicker solution - I would look into wrapping up SQL in the m query language - under edit queries, connect to a table - then under advanced editor go in and paste in SQL based on code found via the internet. Probably a trial and error process ... for me at least.
I would NOT do direct Query - the search on slicers can't find jack crap in redshift based on case sensitivity.