Forum Discussion

Raf_Draulans's avatar
Raf_Draulans
New Member
4 years ago
Solved

The query does not import all rows

I try to import a rather large file (50mb) into power query. It is a sort of .xml file (when I open it in XML.spy it gives me an eror but I can see the structure and when I open it in excel it opens ...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Raf_Draulans ，

     

    The solution provided in the documentation is to set option InferSheetDimensions to "true".

     

    Add option InferSheetDimensions in the Advanced editor of Power Query Editor, like this:

            Excel.Workbook(File.Contents("C:\MyExcelFile.xlsx"), [DelayTypes = true, InferSheetDimensions = true])

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi Raf_Draulans ，

 

The solution provided in the documentation is to set option InferSheetDimensions to "true".

 

Add option InferSheetDimensions in the Advanced editor of Power Query Editor, like this:

        Excel.Workbook(File.Contents("C:\MyExcelFile.xlsx"), [DelayTypes = true, InferSheetDimensions = true])

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

SamHenderson's avatar
SamHenderson
New Member
3 years ago

Amazing answer. First post I have read that gave me a solution to missing data in PQ.