Forum Discussion

gp10's avatar
gp10
Advocate III
3 years ago
Solved

Redshift and Gateway issue

Hi community, I'm facing issues when trying to create a dataflow with Amazon Redshift data. The data that need to ne imported are over 1bn rows. I have tried to connect both with the Amazon Redshif...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago
    Then the pbix file is so big that it cant be published.

    You can bootstrap the incremental refresh partitions to keep the original size under 10 GB. Then use XMLA refresh to fill each partition separately. This will then allow you to load datasets that are half the size of your capacity, and supposedly even beyond.

lbendlin's avatar
lbendlin
Super User
3 years ago

Use DAX Studio or SSMS to check the partitions and their content. Refresh individual partitions as needed.

gp10's avatar
gp10
Advocate III
3 years ago

I did that several times but still the data are wrong. Especially in the last month where it creates daily instead of monthly partitions. It looks like its returning double and more than the actual rows. 
Could this have to do with the Amazon Redshift power bi connector?