Power BI Semantic Model Best Practices (PIMP) Script!

Learn how to run a series of scripts in Tabular Editor 2/3 to (PIMP) out your Power BI semantic model. Quickly and efficiently enhancing it's design, features, and other items! Tune in to learn more!
GUEST BIO (Alexander Korn) 👤
Expert in Power BI and experienced business analyst with a demonstrated history of successfully implementing BI reporting solutions in various industries. Further skills: SSAS, IBCS, PBIRS, Excel, T-SQL, DAX, MDX, and PowerShell.
RELATED CONTENT 🔗
Link for the script -- github.com/KornAlexander/PBI-...
PBI Idea for “Write Operations for External Tools” -- ideas.fabric.microsoft.com/id...
Alexander's Blog -- actionablereporting.com
Alexander's Employer -- www.hico-group.com/
Alexander's LinkedIn -- / alexanderkorn
BECOME A CHANNEL MEMBER 🎉
-- / @havensconsulting
CHECK OUT OUR MERCH STORE 👕
-- havens-consulting.creator-spr...
LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
-- / havensconsulting
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsulting.net
Blog -- www.havensconsulting.net/blog-...
Blog Files -- www.havensconsulting.net/blog-...
Files & Templates -- www.havensconsulting.net/files...
Consulting Services -- www.havensconsulting.net/consu...
Online Courses -- www.havensconsulting.net/onli...
Contact & Support - www.havensconsulting.net/conta...
EMAIL US AT 📧
[e-mail]
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #tabulareditor

[@Jeronimus0211]

lovely script, ill be sure to give it a try

[@guillermoosorio6099]

Hi!
I've been following your Power BI script tutorial and have encountered an issue where the model.bim file is not present in the .Dataset folder after saving as a .pbip. I'm on the latest Power BI version and followed all the steps. Could you provide any guidance on why this might be happening or how to resolve it?
Thanks for the great content and for your help!

[@alexanderkorn1662]

With TMDL, the .bim files are removed. So make sure to activate the project files without the current TMDL preview. I just recently updated the C# PIMP script. So you can use the script also directly against the PBI Desktop model without the need to save, reopen and replace the .bim file. The script will than not add PQ tables, but it will add calculated tables such as date dimension or calc groups or explicit measure creation or empty measure table as calc tableall still possible!
Alternatively you could also try to save it as folder that could work as well.
With TMDL and the new upcomming PBIR folder scructure the whole process becomes even better. We can do now even with PowerShell simple copy+paste and search+replace scripts. I created one "IBCS Power BI Generator" for this.
For any additional question feel free to let us know.