Forum Discussion

natabird3's avatar
natabird3
Icon for Skilled Sharer rankSkilled Sharer
6 years ago
Solved

Excel max row limit reached, what to do to continue same structure?

if i use excel file to connect data in power bi what happens if my number of rows is maxed and i need to continue with the same file structure simply continuing the rows entries? For example, i have ...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi natabird3 

     

    You can split your excel into multiple files and later append in power query.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi natabird3 

 

You can split your excel into multiple files and later append in power query.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

 

natabird3's avatar
natabird3
Icon for Skilled Sharer rankSkilled Sharer
6 years ago

works perfect thanks. Does it have a limit on how many times it can be appended? 

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi natabird3 

     

    I don't think there is a limit but if there is it must be quite high as I never reached it.

    I would suggest you put all your files into an isolated folder and use the Get Data > Folder option as below.

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.


     

    • natabird3's avatar
      natabird3
      Icon for Skilled Sharer rankSkilled Sharer
      6 years ago

      ok perfect. Thanks for the help.