Forum Discussion
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_DecklerCommunity 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.
- vanessafvgCommunity Champion
do you have any filters on?
have you disabled the load into the report?
more help if you show what hasn't been filtered?
- jagdishpatilRegular 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_DecklerCommunity 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-msftMicrosoft 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