Forum Discussion

rkshanmugaraja's avatar
rkshanmugaraja
Frequent Visitor
3 years ago

Dataflows Status code: 400 description: 'The block list may not contain more than 50 000 blocks.

Hi All   On Power BI Premium capacity, I created a dataflow to push a large fact table with 1 billion rows. the refresh failed with the error message  "'. Status code: 400 description: 'The block l...
Dataflow
rkshanmugaraja's avatar
rkshanmugaraja
Frequent Visitor
3 years ago

Thanks Ibendlin, 

 

How do I determine the partition granularity not to exceed the 50000 blocks on Blob storage ? 

Is there any correlation between partition and this block size (50k) or is there any best practice to avoid this ? 

I need to last one year data with last 1 month incremental refresh. 

 

Many thanks in advance.