Categories: SSAS

Stop Previewing the bim.layout File in SSAS Tabular

A quick blog post for future reference, because I know I’ll bump into this again someday.

When you’re working with a team on a Analysis Services Tabular project, you most likely will check your code into some sort of source control (yes, you do. If not, start tomorrow). One of the problems is the layout of the measure grid. This is stored in the model.bim.layout file and of course this isn’t kept in source control by default. This means that when I create new measures and organize them neatly in the grid and check in my changes, the layout file isn’t updated on the server (because it’s not included). Every developer has its own layout file. Which means that when another dev opens the model, the nicely organized measure grid is gone; all measures are typically splashed across two rows.

Annoying.

You can “solve” this by adding the .bim.layout file to source control (right-click the project, choose Add and then Existing Item).

Every time you work on the model, you check out the .bim.layout file as well. When you’re done, you check in all changes. When another dev starts working on the project, a get latest is performed to get the latest version of the layout file (typically you get a conflict error and you have to tell TFS to overwrite the local file). Case closed? Now we introduced a new issue: every time you want to check out the layout file, Visual Studio insists on opening it first. And that can take quite some time. Luckily you can disable this (hence the title of this blog post).

Go to Tools > Options… > Environment > Tabs and Windows. Deselect “Allow new files to be opened in the preview tab”. All done.


------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

Recent Posts

Book Review – Microsoft Power BI Performance Best Practices

I was asked to do a review of the book Microsoft Power BI Performance Best…

3 days ago

Create a Numbers Table in Power Query

This is a quick blog post, mainly so I have the code available if I…

7 days ago

Microsoft finally adds Tenant Switcher for Fabric / Power BI

Praise whatever deity you believe in, because it's finally here, a tenant switcher for Microsoft…

1 week ago

Book Review – Humanizing Data Strategy by Tiankai Feng

This book was making its rounds on social media, and the concept seems interesting enough…

1 week ago

Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions

I'm hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC.…

3 weeks ago

dataMinds Connect 2024 – Session Materials

The slides and scripts for my session "Tackling the Gaps & Islands Problem with T-SQL…

1 month ago