Forum Discussion
Data in Query Editor and Table View but not in Report
Hi Team,
I hope you are all staying safe. I have an issue with my data that I would like some assistance with. Please keep in mind I am new to PowerBI and am building on an existing dataset which may have resulted in missing a step.
I recently updated my queries for two table to include an additional column from two different tables in our SQL database. After applying the query changes, I can see the data has pulled up to yesterday in both Query Editor and Table View (when I ran this, 4/30/2020). I then went to the Reports section and refreshed the Report, but no success.
To utilize a single visual as an example, dates jump from 6/29/2019 to 5/1/2020, missing everything in between. I have confirmed that there are dates between these two data points in the query editor.
Could you please point me in the right direction?
Thanks,
Crlll
Hi crlll ,
has a filter been set in the report?
https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter
3 Replies
- mwegener
Most Valuable Professional
Hi crlll ,
has a filter been set in the report?
https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter
v-yingjlCommunity Support
Hi crlll ,
Except setting filters in the report like @ mwegener mentioned, if you have applied some slicers in the report, it may be another reason which could cause it, especially snyc slicers that usually be ignored.
You can refer: Slicers in Power BI
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.