Forum Discussion
jaradc
8 years agoFrequent Visitor
How to Import a Subset of Data From Amazon Redshift
I'm new to Power BI, "M / Query Editor / Power Pivot", and DAX language. As a new user, I have several questions after spending the last 2 days getting familiar with it. I am connecting to a Ama...
v-chuncz-msft
Community Support
8 years ago
Many operations in Query Editor are applied to the underlying Amazon Redshift database itself (if supported). You may try DirectQuery mode and do research into The Advanced Editor. To create a PivotTable, just load data into a data model and use a Matrix visual.