cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
corbusier Advocate III
Advocate III

Redshift source, 15 million rows: DirectQuery vs Import?

I'm working with a Redshift data source that has 15 million rows. These are already pre-aggregated somewhat. It's just a lot of data. I've restricted the query to 8 dimensions and 3 metrics, and I'd like to build a couple of metrics on top of those. 

 

I need to use Power BI to empower users to click around and discover data and trends. 

 

Now, I like DirectQuery for this, except for the problems here: 

1. No automatic date hierarchies, so drill-down in charts (Year -> Quarter -> Month -> Date) is missing. The charts are automatically at the lowest (date) level.

2. I couldn't use Power Query to split up a column, so I used SQL, which luckily worked. 

3. Various DAX functions are just not available. For example I'd like to compare YTD, MTD, WTD, current week to last week and so on, which is not an option with DirectQuery. 

 

On the other hand, switching to Import takes an interminable amount of time for the entire 15 million rows to be loaded. It is also not an operation Redshift is optimized for. 

 

Ideally I'd like to have as much of the processing offloaded to Redshift. Is Power BI even the right tool for this job? I'm starting to have doubts. 

 

Any help would be appreciated.

1 REPLY 1
Community Support
Community Support

Re: Redshift source, 15 million rows: DirectQuery vs Import?

@corbusier,

 

Check No built-in date hierarchy in Implications of using DirectQuery.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors