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?
2. What and where are we actively visualizing and offering as filters to users?
3. How much of our reports/pages/visuals are being looked at and by who?
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!
