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

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

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