Fabric Multi Workspace Usage Metric Of Reports

This notebook works inside Microsoft Fabric with Lakehouse

Tables created

Name	Load type	For Report Purposes
ReportLoadTimes	Increment	✅
ReportPages	Overwrite	✅
ReportPageViews	Increment	✅
Reports	Overwrite	✅
ReportViews	Increment	✅
Users	Overwrite	✅
WorkspaceViews	Overwrite	✅
UsageMetricsDatasets	Overwrite	❌

Usable schema

Implemented

• Generation of Usage Metric datasets
• Time-out handling for workspaces in paused capacities
• Handling for workspaces with VIEW permissions
• Backlog of already existing Usage Metric Datasets in Workspaces
• Handling responses without data
• Incremental DAX query for non-first runs
• Removed duplicates from the table Users

Currently known issues of solution

• Initial load of data from Usage Metric Datasets can contain more than 100k rows or 1M values. (needs to be solved by provided DAX query like in: Execute Query endpoint - Get your data from datasets)
• Initial load to get or generate datasets for Usage Metric can take quite a long time because of the generation process

Planned updates

• Convert String Stored Date / DateTime Values into the correct format
• Support for dynamic larger data extraction
• Basic report template