Tabular model.bim set to ‘read only’ in AdventureWorks Codeplex Tabular Models.

If you download the AdventureWorks tabular model from CodePlex, then the files are marked ‘read only’. When I tried to open the file, I got a number of things happening. I’ve now changed so it isn’t read-only – no surprise there!

– I couldn’t see any of the ‘normal’ buttons in Visual Studio. So, for example, I had ‘Tools’ and ‘Window’, but I couldn’t find ‘Table’ and ‘Column’.

You need to point the tabular model at your on instance of the tabular model in two places:

– Click on the Model.bim file, and select ‘Properties’ and point the tabular model at the correct instance
– Click on the Project, and select the updated Properties information under ‘server’.

Then, double-click the Model name, and everything should be fine. You can see your buttons properly, and can process the tables and see the AdventureWorks data.

You will have to change the connection to the source database as well as the tabular model instance.

Hope that helps,
Jen

Women in Technology Lunch at SQLRally Nordic

We are delighted to announce that there will be a ‘Women in Technology’ lunch at SQLRally Nordic in Copenhagen, Denmark on 2nd October! The lunch will be held at the lunch break (obviously!) and it will be held at the venue, which will be announced at the event unless I hear earlier.

The SQLRally Nordic event in Copenhagen is a great opportunity to meet and network with your peers. To make it easier for you to meet others, we are arranging an informal lunch with a focus on ‘Women in Technology’ so you can meet your peers to share knowledge, stimulate ideas and build a network.

The topic of discussion for lunch is: ‘Women in Technology: Mentoring, Networking and Careers’ We look forward to hearing your thoughts on a range of questions. How we can attract younger women into IT? How can we keep them there? How does the new world of ‘data, data and more data’ impact careers? What’s the best way to progress your career – male or female?
To meet for lunch, please meet us at at lunchtime on 2nd October and we look forward to meeting you then. 

 

BISM Connection is missing from Document Types in SharePoint

If you want to connect Power View to your Tabular model, then you need to create a BISM Connection file. What happens, however, if you try to create a new connection in your SharePoint Data Connections library, and cannot find the BI Semantic Model Connection document type under ‘New Document’? It is missing! Why?

This usually means that you haven’t enabled the Content Type for the Data Connections library, or wherever you want to store your Data Connections.

To do this:

  • In SharePoint, go to ‘Library Tools’ for the Data Connections library
  • Go to Library Settings
  • About half way down, go to ‘Add from Existing Site content types’
  • Look for ‘BI Semantic Model Connection’ and add it to the list of available Content Types
  • When you return back to the ‘Settings’ page, you should now see the option available for BI Semantic Model Connection.

Here are some handy Books Online links, in case they help you to create the Connection file:

Create a Shared Data Source for a Data Model

Create a BI Semantic Model to a Tabular Database

Use a BI Semantic Model in Excel or Reporting Services

I hope that helps to save someone some time!

Jen x

Power View User Data Source Credentials Error and Resolution

What happens if Power View loses its connectivity to the source? Or, let’s envisage another scenario: you have a PowerPivot and corresponding Power View, taken from your development system. How can you move them to the test system, and make sure that the Power View still recognises its source?

If Power View cannot connect to the source, you might get an error message like this:

If you click on the ‘Show Details’ button, you get an error message such as:

rsInvalidDataSourceCredentialSetting400The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified.http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInvalidDataSourceCredentialSetting&ProdName=Microsoft%20SQL%20Server

What do you need to do to resolve this issue?

All is not lost.

– Go to the Gallery where the Power View is located in SharePoint, if you have correct privileges
– Make sure that the ‘View’ is set to ‘All Documents’. To check, go to ‘Library Tools’, and select ‘library. Make sure that Current View is set to ‘All Documents’.
– To the left of the Power View, click the tickbox. Slide the cursor along until you bump into the end of the column, and click the chevron so you get a menu. Choose the option ‘Manage Data Source’.
Click on ‘EntityDataSource’ and look for Connection String. If you’re connecting to PowerPivot, insert the path to the PowerPivot. Here is an example:

Data Source=”http://sapphire/sites/PowerPivot/PowerPivot Gallery/AdventureWorks TechEd Top.xlsx”;

Then, select your preferred Credentials for connecting to the Source Power Pivot. That should sort you out!

Hope that helps!
Jen

SQL Server Data Tools – September 2012 Update and updated Power Tools are released!

The SSDT team’s continued commitment to delivering regular, frequent releases of SSDT to the web has shown itself once again! There’s a new download available to you, and you can get it here.
Also – the SSDT team have produced new Power Tools. The full blog list is here. The purpose of the current blog is to release this information to Business Intelligence people, in the hope that some of this news will be relevant and provoke some interest amongst BI people to take a look! The full SSDT Team Blog is here
So what is all the latest news for Business Intelligence people? Here is a summary of the main topics:
Visual Studio 2012
 – this release of SSDT supports the Visual Studio 2012 shell.  
 – contains several bug fixes to the SSDT version that shipped in Visual Studio 2012
 – release can be applied  as an update on top of Visual Studio 2012 Professional, Premium, and Ultimate Editions

Updated SSDT Power Tools
The September 2012 update is compatible with updated Power Tools. Take a look here:

 
 These updated Power Tools rely on the September 2012 update, so make sure that you install it first! 
 

LocalDB Configuration Improvements
  – easier to create a new single localdb instance called Projects to host all the project debug databases.  
– enhancement to SQL Server Object Explorer by surfacing the default localdb instance and enabling the deletion of localdb instances.
 
Support for ANSI_NULLS and QUOTED_IDENIFIER Properties
  – now, SSDT support database objects with non-standard ANSI_NULLS or QUOTED_IDENTIFIER properties on project and script files.
I hope that helps – so head on over to the SSDT Team Site and take a look at the September 2012 update and the updated Power Tools.
Enjoy!
Jen

‘Women in Technology’ at Munich SQLSaturday 170

‘Women in Technology’ at Munich SQLSaturday 170
We look forward to welcoming you to SQLSaturday 170 in Munich! This will be the first SQLSaturday in Munich, and we’d also like to invite you to another innovation!
The SQLSaturday 170 event in Munich is a great opportunity to meet and network with your peers. To make it easier for you to meet others, we are arranging a lunch with a focus on ‘Women in Technology’ so you can meet your peers to share knowledge, stimulate ideas and build a network.
The topic of discussion for lunch is: ‘Women in Technology: why does it matter?’ We will talk about whether female team technical members can influence product development and innovation, and whether companies benefit from having more women working in technology.
To meet for lunch, please meet us at the canteen at 12:30 PM on 15th September, 2012 and we look forward to meeting you then.
„Women in Technology“ beim SQLSaturday 170 München
Wir freuen uns darauf, Dich beim SQLSaturday 170 in München begrüßen zu können! Dies ist der erste SQLSaturday in München und wir möchten Dich in diesem Rahmen zu einer weiteren Premiere einladen!
Der SQLSaturday 170 in München ist eine großartige Möglichkeit Fachkollegen zu treffen und Dich mit Ihnen zu vernetzen. Um es für Dich noch einfacher zu machen andere kennenzulernen, organisieren wir zum Mittagessen einen Roundtable mit dem Fokus auf ‘Women in Technology’, mit der Gelegenheit Wissen auszutauschen, Ideen zu generieren und ein Netzwerk zu bilden.
Das Thema für die Diskussion ist: „Women in Technology: why does it matter?“. Wir werden darüber sprechen, ob weibliche Teammitglieder die Produktentwicklung und Innovation beeinflussen und ob Firmen einen Vorteil erreichen, wenn sie einen höheren Frauenanteil in ihren technischen Teams etablieren.

Bitte treffe uns für diese Diskussion beim Mittagessen um 12:30 Uhr in der Kantine. Wir freuen uns auf Dich.

‘Women in Technology’ at Munich SQLSaturday 170

We look forward to welcoming you to SQLSaturday 170 in Munich! This will be the first SQLSaturday in Munich, and we’d also like to invite you to another innovation!

 The SQLSaturday 170 event in Munich is a great opportunity to meet and network with your peers. To make it easier for you to meet others, we are arranging a lunch with a focus on ‘Women in Technology’ so you can meet your peers to share knowledge, stimulate ideas and build a network.

The topic of discussion for lunch is: ‘Women in Technology: why does it matter?‘ We will talk about whether female team technical members can influence product development and innovation, and whether companies benefit from having more women working in technology.
To meet for lunch, please meet us at the canteen at the lunch break, and we look forward to meeting you then.