Top 20 Managed Hosting Providers

When selecting a managed hosting provider, the good news is that there are more choices today than ever before. Unfortunately, that amount of selection can also make choosing the right provider harder than ever before. To help you make the best, most informed decision, we have put together this list of the top 20 managed hosting providers, including a brief description of what makes them the best and why they might be the right choices for you. Listed in random order. 1. Albatross Cloud Albatross Cloud is an enterprise-level infrastructure and managed hosting provider, offering complete cloud...

read more

What is PowerBI?

Business owners have long wanted convenient ways to compile usable data into a workable, advantageous format. Many solutions have been discovered, but most have been cumbersome, quickly outdated, or too rigid to provide truly useful information. Enter Power BI. Power BI is a product from software giant Microsoft, and it transforms your company’s data into rich visuals that you can collect and organize to help you focus on what you need to know. The software allows you, as a business owner, to spot trends, identify strengths and weaknesses, and make workable action plans based on...

read more

Unable to Open File "Compressed Stream" in Excel Power Pivot and Analysis Services (SSAS)

Overview of the error message This error happens in Excel when you try to refresh some data from SQL Server Analysis Services (SSAS) and the refresh returns the error "Unable to Open file compressed stream". Often this workbook is a using PowerPivot.   Solution This solution fixes the issue most of the time. In SQL Analysis Services: Open Microsoft SQL Server Management Studio Connect to the instance of Analysis Services (SSAS) Right click on the server node Click Properties Click General Find and modify "Network \ Responses \ Enable Compression" to FALSE...

read more

How to Delete a Power View Report from the Power Pivot Gallery

To delete a Power View report (rdlx) file from the Power Pivot SharePoint Gallery, you have to first change the view to a standard view: Navigate to the PowerPivot Gallery Click on the Library Tab –> Click on the drop down of the Views available –> Select All Documents This will reveal the documents and reports in your library. Select and delete the Power View...

read more

SharePoint 2013 Sing in as different user missing

In SharePoint 2010 you may have gotten used ot the feature or menu option that allows you to sign in as a different user in the browser. In 2010, you would click on your user name at the top right then click on ‘sing in as a different user’. This option does not show sometimes in SharePoint 2013. A Quick workaround is to go to this URL to force the browser to ask you to sign in as different user: http://siteurl/_layouts/closeConnection.aspx?loginasanotheruser=true Good...

read more

Scheduling Auto Refresh for PowerPivot Workbook

How to Setup A Refresh for your Workbook On the workbook that you wish to create a refresh schedule for, select the … that appear by the workbook –> Select the … that appears in the menu –> Select Manage PowerPivot Data Refresh Complete the form that appears below. Click the Enable Checkbox Set your desired refresh schedule. For the Credentials Field, "Connect using the credentials saved in Secure Store Service (SSS) to log on to the data source", enter the ID provided to you exactly as it appears. Under "Data Sources", Select the data sources...

read more

Accessing Power View Report Builder in SharePoint 2013

SharePoint 2013 allows you to create Power View Reports directly in the browser from Excel Workbooks. To get the Power View Builder: First Make sure you have the Excel files uploaded to the PowerPivot Gallery Library. This can be found on the left menu: Secondly, make sure you use Internet Explorer to do this because it is the only browser that supports Silverlight. Then: While in the PowerPivot Gallery, click the Create Power View Report icon on the right corner of the workbook You will then see the Power View Report builder screen ...

read more

Saving SharePoint Username and Password Credentials in Internet Explorer

Summary of Issue When you try to access a SharePoint site, it may prompt for a Windows username and password like this: Even if you click on "Remember my credentials" checkbox in the dialog above, it seems to never remember the credentials and the password prompt keeps popping up everything you visit the site. Or even when you try to open documents from SharePoint using Microsoft Office (Word or Excel). Cause This is by design in Internet Explorer because your site is not explicitly trusted. Solution The solution to this is to trust the site and save your credentials. Follow the...

read more

How to Add New User to PortalFront SharePoint Site

Overview: In order to grant access to new users to your site, you must first have the user created in the Admin Center (NeoChief) and then you must grant them the permission you need to SharePoint. STEP 1: Create a New User in Admin Center Log into  https://client.portalfront.com Click on Manage Users Click on Add User Complete the form Click Create At this point the user will be in the admin center, you will need to grant the user permission to SharePoint. STEP 2: Grant Permission to the User in SharePoint If using SharePoint 2013 follow those steps: Log in with your username...

read more

PortalFront SharePoint Slider Preview – Installation

The instructions provided are for the Preview version of the PortalFront SharePoint Slider. For the full version visit SharePoint Slider. What is provided A zip file with the files needed Instructions [Important Note] – If your site collection is  not located at the root  of your domain, then please follow the additional instructions below “My SharePoint Site URL has “/sites/” in it” to make sure the slider shows up. Usually you can tell if your site is not at the root of your domain when you see “/sites/” in your URL. Copying the files Go to...

read more

SharePoint page loads funny – IE compatibility view

We have seen numerous issues with client Internet Explorer (IE ) browsers not rendering SharePoint pages properly. The symptoms may include page not loading or page partially loading. The site actions -> site settings returns sometimes returns an error or doesn’t load and overall a ‘strange’ browsing experience is seen by the user. This happens only in IE 8 or 9. The site will load fine is just about any other browser like Chrome, Firefox and Safari. What is the issue then? Well it looks like it’s something called ‘compatibility view.’ It is something...

read more

SSAE 16 is the new SAS 70

As a follow up to our previous blog title What does it really mean to be SAS 70 Type II Datacenter?, we want to keep the hosting customers and cloud shoppers up to date on the latest developments with SAS 70 Reports. Moving forward, the Statement on Auditing Standards No. 70 (SAS 70) report which most of us are accustomed to is aging and has been replaced by a very similar report called Statement on Standards for Attestation Engagements (SSAE ) No. 16. This is a good step forward in the auditing world that refines and updates the auditing process of 1992 born SAS 70. Most of the changes are...

read more

Streaming Videos on SharePoint

We have had customers ask, “how do we upload videos for streaming on SharePoint”? Well there maybe a few options here, but we’re offering what we think is the easiest most practical option that covers most use cases and requirements. Why not just upload video to SharePoint? – you may ask Good question. Uploading a video to a doc library is a bad idea. A doc library only supports about a 50 MB file sizes. Probably not going to cut it. Also, the video will be stored in the database. You will not be doing your DB, DB admin or your server any favors here. One more reason, the...

read more

What does it really mean to be SAS 70 Type II / SSAE 16 Datacenter?

UPDATE: Note that SSAE 16 is the new SAS 70 Many of us have heard that a SAS 70 Type II / SSAE 16 data center is what we should be looking for in hosting provider; however what does SAS 70 Type II / SSAE 16 really mean and what does it tell us about the data centers? First off, don’t be fooled by marketing lingo. There is no such thing as a data center being SAS 70 Type II / SSAE 16 “Certified” or SAS 70 “compliant” like many data centers and hosting companies claim. SAS 70 Type II / SSAE 16 is an auditing statement or report (not a certification) that is...

read more

Hosted PowerPivot in SharePoint 2010

In today’s blog, I want to talk about a topic that is a little bit obscure to most SharePoint users: and that is PowerPivot. PowerPivot is a tool that enriches data analysis with Microsoft Excel 2010. This includes creating self-service business intelligence solutions and Microsoft Excel and possibly even sharing this data in SharePoint. This all sounds good. However, I would really like to pinpoint exactly the value proposition of PowerPivot and features that it adds on top of the standard Excel functionality that make it appealing. And from some brief research I found the answer from...

read more

Which Edition of SharePoint 2010 to Start with?

We have been recently asked the question, which edition/version of SharePoint do we need? And what is the difference between them? The reason we get this question often is because users that are relatively new to SharePoint see many buzz words on the site such as SharePoint Foundation SharePoint Standard SharePoint Enterprise SharePoint 2010 And SharePoint 2007 WSS Windows SharePoint Services We are the first to admit, that yes, it could get confusing. But here’s the break down. First, there is a clear distinction between a SharePoint version and a SharePoint edition. A SharePoint...

read more

Fantastic 40 Templates in SharePoint 2010

We have had many customers that receive their SharePoint 2010 sites ask us “Where are the SharePoint application templates?” In reference to the fantastic 40 templates by Microsoft that were found in SharePoint 2007. One of the more popular templates was the Project Tracking Workspace and the Help Desk template. Unfortunately, the fantastic 40 templates are no longer available in SharePoint 2010. At least they weren’t redesigned for SharePoint 2010. Therefore we don’t offer them in our hosted SharePoint offering. We are not exactly clear as to the reason they are no...

read more

PerformancePoint & Fast Search in multi-tenant SharePoint 2010 hosting

We have been asked recently if PerformancePoint and Fast Search are supported in SharePoint 2010 multi-tenant hosting. For those who don’t know what multi-tenant is, it’s simply the ability for one server to host multiple customers on the same farm, often here at PortalFront Hosting we refer to that as shared hosting. The answer is that PerformancePoint and Fast search are not supported in when it comes to shared space. It is not the news we would like to report, but as per our understanding from Microsoft it is not supported. This is also true for the Microsoft SharePoint Online...

read more

Portal Front Publishes a SharePoint 2010 style WordPress Theme

We recently created and published a WordPress theme that looks like the standard out of the box SharePoint 2010 site. We hope that the SharePoint community would find it useful. If you are a SharePoint fan, or a blogger trying to have consistent branding, or simply a blogger that likes the look of the template feel free to use. We would love to hear your feedback and ideas about it. Here’s the link to download: http://wordpress.org/extend/themes/sharepointforwordpress Here’s a complete HTML version of...

read more

Getting Started with your SharePoint 2010 site.

If you just recently got your Hosted SharePoint site, you may be asking now what? From our experience, there are many common tasks that most SharePoint administrators go through. In this blog, we just want to give you a general direction and some ideas on how you can prep up your site and get it ready for launch. Branding Access Type Creating your team Site design Content loading Enforcing Procedure Branding SharePoint sites can be branded to suit your organization’s profile. The two most common requests to brand a site uploading your logo and defining the color scheme. There...

read more

What are Microsoft Office Web Apps for SharePoint 2010?

Today, we want to unravel an amazing hot and popular  feature that comes with our Portal Front SharePoint Hosting offering. This feature is Microsoft Office Web Applications. But what is it? Microsoft Office Web Apps allow you to view and edit Microsoft Office documents directly from the browser. Knowing this, here are some common follow up questions we often hear: Which applications can you edit from the browser? You can edit Word documents (.docx), Microsoft Excel (.xlsx), Microsoft OneNote documents. Do you need a client installed on your computer to edit, or do you just need a...

read more

SharePoint For Me Launches New Site for SharePoint 2010 Hosting

Finally, it’s here. Our officially renovated website is up and pink and our SharePoint 2010 offering is exciting news! Our team has been working hard to launch our new public site. We redesigned the site to reflect our growth and maturity in the business and wanted something that better represents us and our service. We are eager to continue working with our existing customer and provide exceptional 2010 hosting, SharePoint solutions in both Server 2010 and Foundation 2010 and phenomenal support. We are also eager to get meet new customers and share our success with them. Happy...

read more