Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power Query in Power BI - Not able to ingest data past 10 rows when files are on SharePoint

Power Query, data from a SharePoint Folder, multiple Excel files with same data structure and multiple worksheets, every worksheet has 9 blank rows to start and the 10th row is the header data.   When Combining / Transforming or even just transforming it automatically recognized the 10th row as the header but only displays the fist 9-10 rows of data below.   

 

This is similar to  - Solved: Re: Power Query - Not able to ingest data past 10 ... - Microsoft Fabric Community but with the files now coming from a SharePoint Folder. So that solution (using the parameter InferSheetDimensions = true for Excel files in a local folder) does not work.

 

What's the equaivalent solution for SharePoint Folder queries ?

 

Thanks.

 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Do you happen to know what's in the 10th row of data? Could that row data itself be causing an error?

     

    --Nate

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      The file has 10 blank rows followed by the header, then the data.

      This is the same data as in the previously reference issue, just moved to SharePoint and using load from SharePoint folder.