Forum Discussion
PBI report server ExecutionLogStorage Report Action
Hi Anonymous ,
interesting question 🙂
I only use Power BI Report Server - I don't have render "1" in my executionlogstorage.
I think this is SSRS right?
I found out that only some of the types are use in Power BI Report Server and the others are from the SSRS.
So I think in Power BI Report Server I would use "13" for open reports and in SSRS 13 and 1 - but I guess you must test if it is right. So open a report in SSRS and monitor it via the report in my blog post - you add the 1 as well and than you will see what happend. 🙂 I would try it but I havn't installed a classic SSRS and I don't work with paginated reports.
If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!Best,
Kathrin
KBO, thank you for your reply.
In your report you assigned ReportAction=13 to "ReportOpen", while in the ExecutionLog3 View definition the ReportAction=13 is "ConceptualSchema" (whatever that means😶).
This is what Microsoft defines to create the ExecutionLog3 view:
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,
Therefore, the following questions raise:
- What is the difference between Execute and Render?
- Which of these actions are actually "Open Report" action?
Thanks
what is the diffrence between each of them?