PROLOGIKA BLOG · IDEAS FROM THE FIELD
Practical perspectives on Microsoft Fabric, Power BI, semantic models, and the work of turning data into insight.
Explore the latest articlesTo continue my Report Server Settings in SQL Server 2012 SharePoint Integration Mode blog, here is another example of how to use the new PowerShell-based configuration mechanism to hide a rendering extension. In this case, the script finds an SSRS application called SQL Server SSRS (replace with the name of your SSRS application from SharePoint Central Admin) and hides the XML renderer so the XML…
Read article
I upgraded SQL Server 2012 from RC0 to RTM today on a SharePoint application server which was configured for Reporting Services integration. The upgrade went with no errors but I got this error when requesting reports: The requested service, 'http://amatltapp02:32843/1dacf49a2f7a4a6daa8db5768539893f/ReportingWebService.svc' could not be activated. See the server's diagnostic trace logs for more information. The requested service, 'http://amatltapp02:32843/1dacf49a2f7a4a6daa8db5768539893f/ReportingWebService.svc' could not be activated. See the server's diagnostic…
Read articleI've been honored to be selected by Microsoft to present the Self-service BI using PowerPivot and Power View session for the SQL Server Special Ops Tour in Atlanta on Monday, March 5th. EVENT AGENDA Agenda Speaker 12:30pm – 1:30pm Registration Opens 1:30pm – 2:30pm SQL Server 2012 – The New World of Data Dandy Weyn – FTE – Sr. Tech Prod Mgr 2:30pm – 3:15pm…
Read articleSharePoint is a like an ocean – the further you go, the deeper it gets Ancient proverb Scenario: Configure SQL Server 2012 Reporting Services on a multi-server SharePoint farm with the following topology: WEB1 – Web front-end Server 1 WEB2 – Web front-end Server 2 APP1 – Application server 1 that hosts the Central Administration site APP2 – Needs SSRS 2012 APP2 – Needs SSRS…
Read article
I'll be presenting "Personal BI with PowerPivot v2" for the Atlanta BI Group on Monday, February 27th. Join us to learn when personal BI makes sense and why PowerPivot is the best tool on the market when it does. The focus will be on the new features of PowerPivot version 2 which launch officially in a week or so. For more information and to register…
Read article
My new book, Applied Microsoft SQL Server 2012 Analysis Services (Tabular Modeling), will start shipping in a week with all popular resellers, such as Amazon, B&N, etc. I've been working on it for a few months and I'm excited to have it done. While waiting to buy the book, check the following resources to get you started with PowerPivot and Tabular: - A sample chapter…
Read articleI'm working on minimizing the cube processing for a cube with some two billion rows in a fact table. I put together an ETL package that processes the dimensions with ProcessUpdate following by processing the latest partitions. I've noticed that processing one of the dimensions , which happens to be the largest (some 1 million rows) and most complicated dimension, resulted in partitions scans. The…
Read articleWe had the pleasure to have some 70 people attending our January 30th, 2012 meeting of the Atlanta BI group. Our sponsor, Matrix Resources, was kind enough to give us the auditorium. FisionIO sponsored the meeting. Phil Per-Lee did us a "Prototypes with Pizza" presentation, titled Connecting the Dots. And, Carlos Rodrigues rocked the stage with the main presentation about dimensional modeling. I've uploaded pictures…
Read articleI had to download many ASP.NET pages from the SharePoint Pages library that were used to wrap up the Reporting Services ReportViewer webpart. I wanted the pages as files, so I could deploy them to another SharePoint server. Unfortunately, SharePoint doesn't support selecting and downloading multiple files. But, it does support the WebDAV protocol. Open Windows Explorer and type in the following URL: \\<SharePoint site>\<library>…
Read articleAs you probably now, Reporting Services doesn't allow you to create subscriptions with data sources that use Windows security because subsbscriptions are run in unattended mode. Moving to SQL Server 2012, we'll add Data Alerts to the list. This presents an issue if you use Analysis Services which only supports Windows security. The only option is to use Stored Credentials with the "Use as Windows…
Read article
