I have refreshed data in a report I have been using for for months without issue, and some of the data has dissappeared from the Matrix visuls I am using. The data is still in the query but is not showing in visual.
The data comes from Excel tables.
I have tried recreating the visuals and the data is still not showing.
The column formats are correct in the Query as well.
Is this a bug?
UPDATE: I had created the Excel data in Excel 2010 originally but upgraded to 2016 a few days ago. Having re-saved the Excel workbook in Excel 2010 and refreshed the data. I now works.!