Forum Discussion

jagdishpatil's avatar
jagdishpatil
Regular Visitor
9 years ago

Data not being pulled from Query

Hello,

I update my query each week with data for the days in the week. The query below is showing the data being pulled in from my excel file, but the Data worksheet won't pull the data in when I refresh it (see below).

 

 

9 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    I have no idea what I am supposed to be looking at in those two pictures. You say the data is being pulled in from the Excel file but the data worksheet won't pull the data. I'm confused.

  • vanessafvg's avatar
    vanessafvg
    Community Champion

    jagdishpatil

     

    do you have any filters on?

    have you disabled the load into the report?

     

    more help if you show what hasn't been filtered?

    • jagdishpatil's avatar
      jagdishpatil
      Regular Visitor

      There are no filters, i should clarify, The query includes all the data i've uloaded. however, the tables in power bi doesn't show it. If the data in the tables don't update, i can't apply any filters to report. 

       

      Below is the query: please look at the dates

       

       

      Below is the Tables: please look at the dates

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion

        OK, so the first image is in the Query Editor and the second image is in the Data Model. OK, please go into Query Editor and then Advanced Editor and post the query.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi jagdishpatil,

     

    Could you please mark the proper answer if it's convenient for you? That will be a help to others.

     

    Best Regards!
    Dale