Forum Discussion
Log tables in PowerBI SQL Database
Hello, colleagues. I have a question with PBI SQL database. I saw a SQL table named ExecutionLogStorage. It stores data about reports and who viewed them. And I want to find a table with logs like deleting, changing, replacing (..etc.) of reports and elements. There are some empty tables in PowerBI_CFG SQL database (Event, History..) but I don't understand where can I saw this data. Thanks!
6 Replies
Thanks for answer. I saw these ItemActions:
1. DataRefresh
2. Render
3. FindString
4. QueryData
5. SaveToCatalog
6. Toggle (What is this?)
7. ASModelStream
8. ConceptualSchema
9. Execute
And what about Delete? There is no anymore.
Below is the logic that is in the view in the October 2017 version of PBI ReportServer. I do not see "delete" in there.
CASE(ReportAction)
WHEN 1 THEN 'Render'
WHEN 2 THEN 'BookmarkNavigation'
WHEN 3 THEN 'DocumentMapNavigation'
WHEN 4 THEN 'DrillThrough'
WHEN 5 THEN 'FindString'
WHEN 6 THEN 'GetDocumentMap'
WHEN 7 THEN 'Toggle'
WHEN 8 THEN 'Sort'
WHEN 9 THEN 'Execute'
WHEN 10 THEN 'RenderEdit'
WHEN 11 THEN 'ExecuteDataShapeQuery'
WHEN 12 THEN 'RenderMobileReport'
WHEN 13 THEN 'ConceptualSchema'
WHEN 14 THEN 'QueryData'
WHEN 15 THEN 'ASModelStream'
WHEN 16 THEN 'RenderExcelWorkbook'
WHEN 17 THEN 'GetExcelWorkbookInfo'
WHEN 18 THEN 'SaveToCatalog'
WHEN 19 THEN 'DataRefresh'
ELSE 'Unknown'END AS ItemAction
Obviously as with all ReportServer objects, this logic is subject to change at anytime.
