Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
We are running Microsoft Power BI Report Server Version 14.0.600.434. I am trying to extract useful metadata and usage statistics from the ReportServer DB and to do so I am using dbo.ExecutionLog3 as per the generic Report Server documentation here: https://docs.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-and...
Thanks,
Kieran
@kieranW wrote:
2. My ReportServer DB contains a number of ItemAction values which are not present in the generic Report Server documentation. I assume this is because these are ItemActions that are specific to Power BI Report Server. The key ones are: QueryData, AsModelStream, DataRefresh, SaveToCatalog, ConceptualSchema, Execute, Render and Toggle. Can anyone provide definitions for these?
I know that this question ask about 4 years ago, but while I've been searching for ItemAction definition in Power BI Report Server DB, I've Reaching to this post.
I've found the answer to question number 2 and I will share with you maybe someone like me still searching for it.
"Execution log entries for Power BI reports differ from entries for other report types.
Source: https://learn.microsoft.com/en-us/power-bi/report-server/scheduled-refresh-troubleshoot#executionlog
This information would be helpful. Not really sure what the item action of ASModelStream or ConceptualSchema means in the log files. Help #Microsoft.
Late to the party but would love some help with this. There is no error reporting in Power Bi and we need something to alert us when refreshes fail.
With regards to failed scheduled refreshes I'm going to point you at this thread
You can get some meta data out of the Server database about what is deployed but the execution log seems to be missing most fo the useful detail. I have tried to see if the underlying log files have anything useful in them but stitching back together the execution sequence and what is actually involved is far from straight forward. So you can get usage information but not really any performance information at this point.
There was a thread on trying to get exec stats a while back.
https://community.powerbi.com/t5/Report-Server/Monitoring-and-reporting-on-usage/td-p/377775
As far as I can tell this is still correct there are no perfmon metrics available
S
I am also trying to extract some usage stats and have noticed that the Time columns are always 0. Opening a Power BI report appears to register a 'ConceptualSchema' ItemAction followed by a series of 'QueryData' ItemActions, any subsequent interactions with the report are also registered as 'QueryData' ItemActions.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |