Refresh Excel workbook with PowerPivot
Hi, A while ago the Roadmap for PBIRS had a feature with the ability to refresh Excel with PowerPivot. It's not there anymore, so i guess that feature isn't coming anytime soon. chrisfin had a blogpost showing how we could use a thrid party tool called PowerUpdate to refresh the Excel workbooks. We prefer not using 3. party tools. He also mentioned that anyone could do this with the REST API. So my question is: Is the ability to refresh Excel workbooks with PowerPivot coming natively to PBIRS (anytime soon)? ...Or does anyone have a script which refreshes Excel workbooks on PBIRS that they would like to share with the community. Regards Taico
PowerBI Report + OOS: Excel with AS works, but Excel with PowerPivot fail
Dear Masters, We setup PowerBI Report Server(15.0.1102.235) and Office Online Server(OOS) is one server, also intsall 2 SSAS instances(SQL2012), one for tabluar model, another for PowerPivot mode in same server. We uploaded 2 excel files to PBIRS, ones' source cnnected to SSAS tabular model, it could work well, like add/move dimension. But another file with PowerPivot, it can be open, when we add dimension into Pivot table, error message prompted: We cannot locate a server to load the workbook Data Model. It look seems OOS cannot connect to SSAS PowerPivot mode, we check log file, here is error message: Checking Server Configuration (twtpewgdwdb02d\POWERPIVOT) ... 05/09/2019 11:06:46.53 w3wp.exe (0x20DC) 0x4A88 Excel Online Data Model sql01 Medium --> Check Administrator Access (twtpewgdwdb02d\POWERPIVOT): Pass. Check Server Version (twtpewgdwdb02d\POWERPIVOT): Pass (14.0.1.278 >= 11.0.2800.0). Check Deployment Mode (twtpewgdwdb02d\POWERPIVOT): Pass. Check Server Configuration (twtpewgdwdb02d\POWERPIVOT): Pass. SSPM: Initialization failed on server twtpewgdwdb02d\POWERPIVOT: Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The '\MSOLAP$POWERPIVOT:Memory\Memory Limit High KB' performance counter could not be found. Refer https://docs.microsoft.com/en-us/sharepoint/support/experts-admin/powerpivot-performance-counter-errors, there is no "Disable Performance Counters" in system registry, so...we add manually, but still not fix the error. Finally, follow isstruction, we try to re-create the performance counter, run below command: unlodctr msolap$pwerpivot Error message prompt: Unable to open driver SYSTEM\CurrentControlSet\Services\msolap. Is anything wrong or any suggestion? Many thank!
Cannot Connect to a PowerPivot Data Source from Report Server
Hi, I am trying to move from SharePoint Integrated mode to PBI Report Server. What used to work: - SharePoint with PowerPivot installed - Upload an Excel with PowerPivot data model to SharePoint - Create a SSRS report, indicate the data source as the Excel uploaded to SharePoint (e.g. Data Source="http://sharepoint/mydata.xlsx"). - In Report Builder, I can access the data including the DAX measures etc. What I am trying to do: - Set up Power BI Report Server - Set up Office Online Server (OOS) with Power Pivot configured - Upload the same Excel file to PBI RS - Connect the SSRS report to the PowerPivot file (e.g. Data Source="http://myReportServer/reports/excel/mydata.xlsx") - 404 file not found error I am able to view the Excel file directly in PBI RS with Excel Online configured but just cannot connect to the PowerPivot data model from SSRS. Thanks.