Browse by Tags

You’ve run the import wizard, and imported a bunch of tables into your tabular model. Now you want to import one more from that same connection. How do you do this? What you need is the Existing Connections dialog. To start the Existing Connections dialog, go to Model->Existing Connections or click...

Now that RC0 has arrived I can finally post about security for tabular models. I have put off writing about security because I think the RC0 documentation on this subject is really quite good so I don’t have too much to add. Also, we had a minor feature add for RC0 that is very exciting. You can now...

If you look carefully, you can see my roots showing. No, not my hair – you can see my old job showing. When I came to work on the Analysis Services team, we had to design an “environmentally friendly” Visual Studio package in a hurry using the Visual Studio extensibility framework , same as everybody...

In PowerPivot, the Edit Table Properties dialog box is used for a few things. It is used to add columns to a table, remove columns from a table, and adjust the set of rows included in the table. This works great for PowerPivot. All the data in the PowerPivot model is stored in a single partition, so...

Here is a pop quiz on impersonation when connecting to a data source for tabular models. Question 1: How many impersonation options are supported for tabular models? 2, as shown in the tabular designer 3 4, as shown in SSMS Question 2: My impersonation credentials are validated in the Import Wizard....

Sometimes people ask me for the slide deck to my PASS presentation . I send out the deck, but there is only one slide in there that is worth anything. This post summarizes the only useful slide in the entire deck. Let’s think about this question – why are tabular models necessary when we already have...

Case sensitive, that is. Last year, Denny Lee posted about PowerPivot’s case insensitivity problem . Tabular models have the same insensitivity problem by default. As I mentioned in my previous post on language and collation settings , when creating a new tabular project, the collation used by default...