Forum Discussion
Combining Model and Visual Layer detail with Usage Detail - Internal Analysis Template
Over the last few months, a colleague and I have been working on an internal analysis semantic model that focuses on (and combines) three categories:
1. What do we have in our Data Models?
- Semantic Model Layer
2. What and where are we actively visualizing and offering as filters to users?
- Visual Object Layer
3. How much of our reports/pages/visuals are being looked at and by who?
- Usage Metrics Layer
We've gotten it to a pretty streamlined process so I've uploaded the core scripts, Power BI template, and key steps to Github:
https://github.com/chris1642/PBIVIsualObjectLayer/tree/main
The project includes a PBI template file that will only require a connection update for the visuals/measures/relationships to all work for their Workspace and Reports.
I encourage anyone to use and provide feedback and/or help make it better! This idea began based on m-kovalsky's initial tabular editor script on github and grew from there.
These steps require two things: PowerShell and Tabular Editor 3.
For any C# experts out there, I haven't worked out the C# script to also work with Tabular Editor 2. If someone can take a stab at getting it to work with Tabular Editor 2, it would allow a single-step update via Tabular Editor 2's Command Line Interface and then be useful to quite a few more people!