locked
Data not getting actually refreshed when refreshing an append query - no error messages RRS feed

  • Question

  • Hi.

    I have a query appending the results of 4 queries.

    The 4 queries are retrieving data from excel spreadsheet tables coming from 4 files in a website in my company.

    When refreshing the appending query, not all data is being retrieved.

    The data coming out of 1 or 2 of the 4 queries is not getting refreshed at all.

    And there is no error message to indicate that...

    What could be the reason??? :-s

    Is there any log file to check if any errors existed in the retrieval of data?

    Thank you!

    Tuesday, March 22, 2016 2:36 PM

Answers

  • Hi Krimbu. Are you using Power Query in Excel, or Power BI Desktop? Also, when you say "not all data is being retrieved", are you seeing the old data from one or two spreadsheets, or no data at all?

    Thanks,

    Ehren

    Thursday, March 24, 2016 8:25 PM