Forum Discussion
Edit direct query against Amazon Redshift
Would like to load data from Amazon Redshift in direct query mode and edit the initial query before loading into PowerBI. From an old blog post announcing the connectivity (powerbi.microsoft.com/fr-...
I'm betting it is a permission issue or a feature they don't support. You may need to check forums that specialize in RedShift.
I tried manually entering the SQL through advanced editor. Gave error
Expression.Error: 'Query' is not a valid Amazon Redshift option. Valid options are : 'BatchSize'
I'm betting it is a permission issue or a feature they don't support. You may need to check forums that specialize in RedShift.