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
Hi Anonymous ,
what a coincidence that i just wrote a blog post about this yesterday 🙂
You can use the Demo Report to monitor your basic actions on the report server. There is also a explanation to the numbers.
Best,
Kathrin
If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!
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
HI Anonymous ,
yes thats right every time a report will be open the conceptual schema will load so that is the trigger to know when a report were opened. 🙂
Here a nice explanation of this: https://en.wikipedia.org/wiki/Conceptual_schema
The conceptual schema is like a map - If you open a report a map of the report will be load and thats why this is the same as open report.
Best,
Kathrin
If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!Thank you again for the explanation.
So, so you think we can use 'Render' as a counter to see how many times a report is been opened?
Because when I use the filter for ReportAction=1 (which is render), it seems that everytime I open a report, this action is added to the execution log.I just son't know which one is the most precise, 'ConceptualSchema' or 'Render'?
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
what is the diffrence between each of them?
