The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi all,
I have a problem with data not showing up in one specific report.
I have created a dataflow (and related dataset), on which about 10-12 reports are dependent. However, in one specific report, not all data is showing. The dataflow exists of different OData-feeds to our accounting system, a manually added (date) table and 1 Excel file which is updated manually.
The problem is, in one of my reports, our financial data for the new year doesn't show up. All other reports are working properly, however in this one specific report I'm not able to select or show data after 2021. I have already removed filters and troubleshooted in a newly created report, but this doesn't give me any results. To recreate the whole report would cost me a lot of time, so I'm hoping you can give me some advice.
Thanks!
Hi @Robin9700 ,
Is there any calculation based on date column on that report?
Please share more details like what data source you are using and if there's any difference between that specific report and other reports.
Best Regards,
Jay
@amitchandak I have refreshed both the dataflow and dataset. The data is showing up correctly in all other existing reports, as well as in newly created reports. The problem occurs only in this specific report.
@Robin9700 , Make sure you have refreshed dataflow after you have created or updated it. Tables will not have data unless dataflow is refreshed.
User | Count |
---|---|
65 | |
62 | |
59 | |
54 | |
28 |
User | Count |
---|---|
181 | |
82 | |
66 | |
47 | |
44 |