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

PowerPivot Gallery not loading, showing Install Microsoft Silverlight Message

The Issue Power Pivot in SharePoint used to load a gallery the workbooks and shows a screenshot of each report. However, sometimes you open the browser, navigate to the page and find that it’s not loading with a "Install Microsoft Silverlight" message. Even after installing Silverlight, it still says the same thing. Chances are you you are using Google Chrome. That is the crux of the issue. Google decided that Chrome will no long support many different types of plug ins, in an effort to conform with web standards, so they no longer support PowerPivot Gallery in SharePoint...

read more

Saving SharePoint login Credentials on iPad and iPhone

There is a common need for SharePoint users to access SharePoint sites using iPads and iPhones without having to constantly input their log in information each time. There is no native way in Apple Safari to cache user name and passwords for SharePoint. Any time a site is accessed the user is presented with a login screen like this one. Close your browser, or come back at a later time and Safari will ask again for that login and password. This post talks about some good and viable options to caching / storing your login info iPads and iPhones. Option 1: Using Atomic browser to cache...

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

SharePoint Permissions Guide – Getting Started

Before SharePoint’s time company files and information were dispersed and hard to access. Files were in emails attachments, file shares and print documents. Enterprises and information technologists have been fighting a battles to make this information consolidated and easier to find and access. SharePoint was the perfect tool to house this data and make it accessible at people’s finger tips. Ironically, this solution has created new challenges: The information was too easily accessible and could get to the wrong hands. Information is the enterprise’s most valuable assets....

read more