title: Llimitation while converting big json into csv in Power Query Editor
body: <p>I am trying to import a 150 MB JSON file into CSV. But all the rows have different number of keys. Issue is that excel find the metadata only based on the first 1000 rows and there are chances that new keys/ columns will be present after the first 1000 rows. Excel says: "Limit of 1000 scanned rows reached"</p>
  
  <p>How do I handle this?</p>
  
  <p><a href="https://i.stack.imgur.com/qRTDl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qRTDl.png" alt="enter image description here"></a></p>