Laiq on 21 Nov 2017 13:08:29
In our firm, we are using Power BI to connect Redshift and SQL Server through import and Direct Query. We used to create SQL queries in Advanced option through power BI to connect with SQL Server. This helps to limit the data size as we have billions of record on the source file. But unfortunately this option is not available in redshift. Right now, we are spending lot of time as a workaround to fill this gap. It really helps if something created for this.
Administrator on 18 Apr 2022 20:31:26
2021 Wave 1 Road Map Item - https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave1/data-integration/amazon-redshift-connector-support-native-query
- Comments (11)
RE: Advance Query option for Redshift
This Function must need.
AWS is the most popular and also has highest market share.
Our company is also one of company which join to AWS last month.
before AWS, We use MS-SQL and i'm one of Power BI evangelist in the company.
but now, situation is changed.
I've got a mail from Microsoft that
Power BI doesn't have plan to provide query option for Redshift.
For Data analytics, It doesn't make a sense without query option.
I'm afraid that AWS user will not use Power BI then also lose Loyalty about Power BI.
please provide this function ASAP.