Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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).
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
do you have any filters on?
have you disabled the load into the report?
more help if you show what hasn't been filtered?
Proud to be a Super User!
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
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.
Yes - How do i post the query in the advance editor?
Go to the query editor. Open the advanced editor. Copy the text you find there. Paste it here.
Proud to be a Super User!
Thank you for all your help. I figured the issue out.
Could you let me know how you fixed this? I'm having the same issue. Thanks!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |