Forum Discussion

Kamacete's avatar
Kamacete
Copper Contributor
Jan 22, 2024

Power Queries - update issue

Hi,

I have an Excel (FileA) storage on ShareDrive that is working with power queries from another Excel (ExcelB) storage on Sharedrive. When I press refresh all on FileA some time it's works, other times the Data panel (Queries & Connections) said "xxx" rows loaded. however, when I compare the data that I have on FileB and the Power Query on FileA. the last modifications are not updated.

 

How can I solve this issue?

thank you

 

Excel
Excel for web
office 365
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jan 23, 2024

    Hi Kamacete 

     

    A bit of more context & information would be welcome. For example: you tagged this thread with Excel for Web and I'm not sure I understand why

     

    That said, not quite I've seen a query randomly working yet - assuming there's no mistake in the query code. With the info. you shared the only thing that comes in my mind right now is:

    • At the time where you refresh the query on FileA, changes have been made (but not saved yet) on FileB
    • Kamacete's avatar
      Kamacete
      Copper Contributor
      Jan 23, 2024

      Lorenzo 
      Thank you for your reply.

       

      I identified this topic. because I actually use Excel A online. But let me explain a little better.

       

      There are two folders on Sharedrive:

      -Folder A
      ---Excel A
      -Folder B
      ---Excel B


      In "Folder B," several Excel files containing data (RAW DATA) are downloaded every day, and these files are read-only (ExcelB, ExcelC, ExcelD, Etc.).

       

      On the other hand, I work with "Excel A" every day, as I need data from various files stored in "Folder B." In the "Excel A" file, I created several Power Queries that I update every morning to have the latest data.

       

      This situation has always worked well; however, it often happens that I update the Power Queries in Excel A (it shows that the rows have been loaded), but the latest changes (added data) in Excel B are not reflected in the Power Query.

       

      Is there a maximum number of rows for Power Queries?

      As it sometimes works, I don't quite understand if it's a Sharedrive connection issue or an Excel limitation.

      Thank you.

      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Jan 23, 2024

        Kamacete 

         

        Thanks for this additional info. & for clarifying Excel on Web

         

        Is there a maximum number of rows for Power Queries?

        Theoritically No. However, it depends on what you talk about

        #Rows displayed in the Power Query Editor is limited

         

        On the other hand max. #Rows returned by Power Query on a table on a worksheet has only 1 limitation: the max #Rows a worksheet contains (> 1M if the table header is in row #1)

         

        I don't quite understand if it's a Sharedrive connection issue or an Excel limitation

        You keep talking about Sharedrive. What do you exactly mean with this? Do you actually refer to SharePoint?

Share

Resources