Forum Discussion
Data export format changed after adding Date Last Refreshed card
I'm now having formatting issue when I choose "data export" on the web. I added a "last refreshed date" card to my report, using the following query:
let
Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}})
in
Source
Now (in the data export) the column headings are different, I've lost the filtered headings and row coloring, and at the bottom is this line:
Applied filters:Device Type is Smart PhoneIntune Enrollment is Not enrolled into IntuneCarrier is not Cellhire USADescription does not contain 'PERSONAL'Assigned_Profile is (Blank) or Corporate iOS Device EnrollmentExclusion List.Exclude is not X
When exporting, try selecting 'Summarized Data' instead of 'Data with current layout'
3 Replies
- jdbuchanan71Super User
When exporting, try selecting 'Summarized Data' instead of 'Data with current layout'
- AnonymousNot applicable
Thank you, that helped a lot. However, now the "Applied filters" text is at the top, which I think it was before as well. Is there some way to prevent that?
- jdbuchanan71Super User
No, there is no option to exclude the filter list when you export.