Data not being pulled from Query

[jagdishpatil]

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

[v-jiascu-msft]

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

[vanessafvg]

@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]

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]

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.

[jagdishpatil]

Yes - How do i post the query in the advance editor?

[KHorseman]

Go to the query editor. Open the advanced editor. Copy the text you find there. Paste it here.

[jagdishpatil]

Thank you for all your help. I figured the issue out.

[mkopp129]

Could you let me know how you fixed this? I'm having the same issue. Thanks!

[Greg_Deckler]

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.