topic Re: Connection error from both Create Paginated Report (Preview) web service from semantic model in Report Server

Connection error from both Create Paginated Report (Preview) web service from semantic model

ucmaoTWG — Tue, 04 Mar 2025 17:32:13 GMT

Hello,

I am receiving the below error when trying to utilize the 'Create Paginated report (Preview)' from Powerbi Service.

We currently have pro licenses and no fabric premium SKU. I have created paginated reports that are attached to our azure sql server perfectly fine but when it comes to the report server i am receiving this error, with the attached error logs below.

Any assistance would be greatly appreciated.

Could not connect to the data source.
There was an error communicating with Analysis Services. Failed to create the MSOLAP command.
Timestamp: 2025-03-04T17:28:50.532Z
Root activity ID: c908369f-a604-ff13-e30d-48e2abbac786
Session ID: 00000ff8b717489eb26642bbe8a027a4
Tenant ID: 00989d4d-a4a1-4563-8aab-6420833ac74b
Cluster: https://wabi-us-east2-b-primary-redirect.analysis.windows.net/
Report ID: null
Capacity ID: undefined
ReportViewerVersion: 2025.2.4.1758

{"shellSettings":{"backendInfo":"removed"},"errorInfo":{"notification":2,"title":"Could not connect to the data source.","messages":{"shortDescription":"There was an error communicating with Analysis Services.","longDescription":"Failed to create the MSOLAP command.","correctiveAction":""},"errorCode":"Connection_Error_General","errorSource":"User","internalErrorMessage":"There was an error communicating with Analysis Services.Failed to create the MSOLAP command.","internalErrorCode":null,"statusCode":"400","showDetails":true,"errorContext":0},"nativeVisual":{"reportsList":{"status":"NotSet","value":null},"hostMessageVersion":0,"nativeVisualInitSuccess":false,"selectedReportName":"","rdlParameters":{"status":"NotSet","value":null},"parameterBindings":[]},"render":{"currentPage":1,"sharedElements":{},"reportPages":{},"reportImageSrcs":{},"warnings":[],"lastPageFetched":{"status":"Loading","value":null},"dataSnapshotMode":null,"renderingStatus":{"status":"NotSet","value":null},"bookmarkToLoad":null,"columnWidths":[],"parameters":null,"toggleStates":{},"currentPageHasInteractiveElements":false},"renderPageView":{"totalPages":0,"currentPage":1,"renderingStatus":{"status":"NotSet","value":null},"reportPageSrcs":{}},"renderCommon":{"cancelled":false},"session":{"ids":{"authoringId":"","sessionId":"00002338abea44b799d146b423b114f3","modelId":0,"modelObjectId":""},"interactiveState":{"lastUserInteractionHighResolutionMs":2719.8999999910593,"isVisible":true,"keepAlive":false},"active":true,"isAuthoringMode":false},"reportStructure":{"isReportDirty":false,"switchedLayoutViewInAuthoring":false,"sectionSeparatorPosition":0,"isDraggingSectionSeparator":false,"objectModel":{"status":"NotSet","value":null},"objectModelVersion":1,"serverObjectModel":{"status":"NotSet","value":null},"serverObjectModelVersion":1,"dataSourceSchemas":{"status":"NotSet","value":null},"jsonPatches":[]},"selection":{"fieldSelectionBuffer":[],"selectedFields":[],"selectedTablixStyle":"default","hasQueryError":false},"filter":{"filters":[]},"rplPatch":{"patches":[],"unprocessedServerPage":{"objectModelVersion":0,"pageNumber":1,"page":{"status":"NotSet","value":null}}},"drillThroughState":{"drillthroughParents":[],"isDrillthroughExperience":false},"diagnosticsState":{"lastRenderResponse":{"reportId":"None","timeDataRetrievalms":0,"timeRenderingms":0,"timeProcessingms":0,"rowCount":0,"totalPageCount":0,"contentSize":0,"operationId":"0000000","sessionThrottlingDelayMilliseconds":0,"renderStartTimeUtc":"2025-03-04T17:29:39.446Z"},"renderFormat":"","reportName":"Bagged Run Report Test"},"sortColumn":{},"authoring":{"insertModeType":0,"insertPosition":{"xPositionMM":null,"yPositionMM":null},"addParameterField":null,"parameterToRemove":null,"filterWithParameterToRemove":null},"showSave":false,"showSaveReplace":false,"showPrint":false,"showDiagnostics":false,"showExitAuthoring":false,"isExitingAuthoringMode":false,"isEditable":false,"webAuthoringVersion":null,"isFromReentrancy":false,"isPrint":true,"showExpandButton":false,"defaultPageSize":{"width":279.4,"height":215.9,"unit":"mm"},"reportId":"93bfc9b7-94ff-443b-95e6-5fede15dd207","reportSaveDialogInfo":{"workspaces":[]},"reportSaveInfo":{"reportName":"Bagged Run Report Test.rdl","workspaceId":"1f0b8b69-8250-4427-bd79-11a3cf8de26e"},"reportView":"Interactive","modelId":"","modelObjectId":"","urlParams":"?experience=power-bi","backendInfo":"removed","sessionId":"00002338abea44b799d146b423b114f3","sessionValid":true,"blockingApiCallsInProgress":0,"locale":"en-US","exportSettings":{"ExportToExcel":true,"ExportToLiveExcel":true,"ExportToPDF":true,"ExportToPPT":true,"ExportToMHTML":true,"ExportToWord":true,"ExportToXML":true,"ExportToImage":false,"ExportToCSV":true,"DownloadReport":true,"Print":true},"parameterCount":1,"parametersDirty":false,"toolbarEnabled":true,"loading":{"loadingState":0,"showCancelButton":false,"pageViewLoadingState":"NotSet"},"showDaxQueryDialog":false,"showInsertUrlImageDialog":false,"embeddedImageLoadErrorFileName":"","authoringMetadata":{"createdBy":{"name":"PBIRB","version":"15.7.1801.18"},"updatedBy":{"name":"PBIRB","version":"15.7.1813.16"},"lastModifiedTimestamp":"2025-03-04T17:09:44.4580677Z"},"showToggleDataSummarization":false,"hideStaticMargins":false,"hideSectionDivider":false,"queryRowLimit":500,"editableSection":"Body","virtualizedTable":false,"virtualizedTableOnPage":0,"anaheimConfigurationOptions":{"downloadEnabled":true,"hostMode":"AutoPremium","rdlSecureEmbed":true,"subscribeEnabled":true,"showFavoritesButton":true,"saveAsAllowed":true,"shareAllowed":true,"telemetryBaseProperties":{"rootActivityId":"ffe358b2-341f-84a0-00c2-9990bc0ef587","reportViewerVersion":"2025.2.4.1758","platform":"Web","hostMode":"AutoPremium","userLicense":"Pro","id":"ffe358b2-341f-84a0-00c2-9990bc0ef587","hostSessionId":"7d3007ea-6503-4737-b206-f57cf6339df7","userId":"100320022D7EDDA5","userObjectId":"9dad15c2-efbc-46a6-ad34-1ad38816b68e","reportId":"93bfc9b7-94ff-443b-95e6-5fede15dd207","isInternalUser":false,"tenantObjectId":"00989d4d-a4a1-4563-8aab-6420833ac74b","cluster":"https://wabi-us-east2-b-primary-redirect.analysis.windows.net/","subRoute":"View","capacitySkuTier":"SharedOnPremium"},"telemetryEnabled":true,"telemetryAppKey":"72709f3d-ee45-4fef-a4fb-5eb88a557131","telemetryEndpoint":"","useRtl":false,"printEnabled":true,"platform":"Web","isDebug":false,"pbiDebug":false,"appActions":[],"themeInfo":null,"applyToolBarThemeEnabled":false,"showCommentsButton":true,"annotationsEnabled":true,"generateLinkEnabled":true,"parameterPanelState":"expanded","viewMode":"dynamic","isNewLook":true,"isReportFavorited":false,"reportView":"Interactive","urlReportParameters":[],"presetLocale":"en-US","rdlEditInPBIRB":true,"eimInformationProtectionRdlReportLabelingUI":true,"useReactRenderer":true,"useFloatingToolbar":false,"toolbarPosition":0,"rdlInfiniteScrolling":false,"userDefinedCapabilities":{},"isOpenFromSubscription":false,"editApiTesterEnabled":false,"reportName":"Bagged Run Report Test.rdl","workspaceId":"1f0b8b69-8250-4427-bd79-11a3cf8de26e","useReactParameterPane":true,"parameterControlsUpdate":true,"useTablixImageFields":true,"tableGrandTotals":true,"userLicense":"Pro","exportToExcelConnectedRdl":false,"hasReportWritePermission":true,"rdlVirtualizeTables":true,"ignoreVirtualizationThreshold":false,"pbiExcelAddInDialogControlsInAnaheim":false,"useStandaloneImagesV2":true,"rdlParamAuthoring":true,"rdlSaveSubfolder":true,"useLayoutEditor":true,"hostType":"Web","userOptOutReactRenderer":false,"capacitySkuTier":"SharedOnPremium"}}

Re: Connection error from both Create Paginated Report (Preview) web service from semantic model

freginier — Wed, 05 Mar 2025 09:49:03 GMT

Hey there!

Here are some possible fixes to your problem:

Power BI Paginated Reports require Fabric Premium or Premium Per User (PPU).
Fix: Check if you need an upgrade to Fabric Premium for paginated reports to work.

The error suggests Power BI can’t connect to Analysis Services (MSOLAP).
Fix: Verify your dataset’s connection settings in Power BI Service.

If your data is on-premises, you need an On-Premises Data Gateway.
Fix: Ensure the gateway is installed and running.

Your user account may not have the right permissions for Analysis Services.
Fix: Check security settings in Azure SQL & Power BI Service.

If none of this works, there could be a temporary outage or bug affecting paginated reports. So you should try again in a few hours or tomorrow!

Hope this helps!

😁😁

Re: Connection error from both Create Paginated Report (Preview) web service from semantic model

Anonymous — Tue, 08 Apr 2025 12:14:50 GMT

Hi ucmaoTWG ,

Thank you for reaching out to the Microsoft Fabric Community, and also thank you freginier for providing helpful guidance much of which aligns well with the root causes of the issue you're facing.

The error you're seeing typically indicates a failure to connect to an on-premises Analysis Services data source, often due to a missing or misconfigured On-Premises Data Gateway. Since you're connecting to a report server and not Azure SQL, please ensure the gateway is properly installed, configured, and matches the connection details in your report.

Also, confirm your user account has the necessary permissions on the Analysis Services instance. Regarding licensing, while Pro users can now publish paginated reports to “My Workspace,” deploying them to shared workspaces still requires Fabric Premium or PPU.

For a deeper understanding, we recommend reviewing the following Microsoft docs: Data Gateway Setup, Paginated Reports FAQ, and Publishing Paginated Reports.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thankyou.

Re: Connection error from both Create Paginated Report (Preview) web service from semantic model

Anonymous — Fri, 11 Apr 2025 01:00:14 GMT

Hi ucmaoTWG ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

Re: Connection error from both Create Paginated Report (Preview) web service from semantic model

Anonymous — Mon, 14 Apr 2025 01:11:16 GMT

Hi @ucmaoTWG ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

Re: Connection error from both Create Paginated Report (Preview) web service from semantic model

Anonymous — Thu, 17 Apr 2025 04:03:56 GMT

Hi ucmaoTWG ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.