For one of my queries, I have 1 row data satisfying the condition. While generating report in BIP, that data is saved as sample data. While viewing the report in various formats(PDF, XLS, CSV), only CSV shows that data. PDF and XLS only has the empty table.
This issue is faced in another similar report too. Is it because of any settings chosen or is it because of any reason like the report has too many columns?
Any feedback will be appreciable.