Forum Discussion
Data in Query Editor and Table View but not in Report
Update: without changing anything in the original pbix, it is working today. The ONLY thing that's different from yesterday on my side is that I rebooted my PC. I don't see, how this would make a difference, though.
I will mark this as solved just to close the thread. Thank you for your efforts.
skasper,
Please right click your tables in Query Editor, and check if you disable the "Include in report refresh" option. Once the option is disabled, updated data will not appear in report.
Regards,
Lydia
Thank you Anonymous,
all tables are set to be included in report refresh. I disabled and enabled it again, but to no effect.
skasper，
I am not able to reproduce the issue. The new data don't appear even you click "Refresh" button in report view, right ? If so, how about you open a new PBIX file, re-connect to your data source and re-create the table visual?
Regards,
LydiaI did a quick first successful test with just one out of the 12 tables/queries I have in this pbix. Add to this the 12 pages in the report and dozens of measures and you will understand that I am not very keen on recreating this in a new pbix.
So, I hope this result helps you with finding a better solution than me doing the whole thing all over again and still facing the risk of running into the same problem again, once I am done.
Thank you for your continued help.
skasper,
I make a test in the 2.52.4921.682 version of Power BI Desktop, and I am unable to reproduce this issue. Could you please verify if the new data appears in data view?
Regards,
Lydia