Forum Discussion
PBIRS Web Analytics
Anonymous wrote:
My environment an on premise PBIRS, running many .pbix and .rdl reports. I need to monitor which reports is mostly used by users.
We do this by just running reports over the execution log (see here for details on accessing this log https://docs.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-and-the-executionlog3-view?view=sql-server-ver15 ) We've actually gone a bit further and we copy the data out of the logs into our data warehouse (as the log records are only retained for something like 90 days be default) and we built an SSAS model over the top of that so we have Power BI dashboards showing usage trends for the last 3 years. This means we don't need to do unsupported changes to PBIRS and none of the data needs to be sent offsite.
Hi! thanks for reply!
I had seen you suggested solution, but imagine in a worldwide portal, I need to get country, location and others informations that ExeccutionLog3 not provide, but google analytics do.
Embedded js code in a .pbix file could a good feature for power bi...