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 created some visuals that every month i simply add more data to the bottom of the excel file and update the visuals with refresh. However, now i have reached the bottom of my excel file, therefore, i am unable to siply continue adding to the bottom of the list and refresh, what should i do now to preserve the report visuls and data from full excel file? Any ideas? Your help will be much appreciated. Thanks in advance. 

  • 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.

     

4 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion

    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

      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

        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.