connection
31 TopicsUnable to connect to SQL Server using Report Server but is able to connect using Desktop
I have a set of reports which was published to Report Server and was working until recently. Reports include both Direct Query and Import reports. It stopped working now. The credentials are working fine if I try Manage > Data sources > Test connection. They work when the report is open in Power BI Desktop as well. When trying to run the direct query report, I get below error: We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly. Request ID <> Time <> Service version /powerbi/libs When when scheduled refresh is run for Import reports, I get below error: SessionID: <> [0] -1055784932: The credentials provided for the SQL source are invalid. (Source at <server;database>.). The exception was raised by the IDbCommand interface. [1] -1055129594: The current operation was cancelled because another operation in the transaction failed. [2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.Solved2.3KViews0likes3CommentsProblem connection power bi in onedrive cloud
Hello. I need help please. I made a dash connection to the ondrive cloud. Using direct cloud path on ondrive. And I'm leaving the automatic update in the power service, but it's giving the gateway an error. Reporting that the gateway is offline. Is there a possibility for the dash to be automatically updated using the direct path from the OneDrive cloud? How can I do it? I appreciate all the help.Solved769Views0likes2CommentsInfor ERP XML files Connecting to Power BI Reporting (currently use INFOR Plug-In to SSRS)
Current situation that we have in Infor ERP system ,user rendered SSRS report in HTML, PDF or XLS formats and see it as it would be pure Microsoft . Behind the scenes, output Infor ERP XML files (!) connect between SSRS report dataset to Infor ERP LN reports, with help of Infor ERP provided Plug-in. We need to smoot migration to Power BI Paginated Reports with old SSRS reports. As we understand SSRS report design file (.rdl) can be used in Power BI, with minor changed. We are looking forward for connector Infor ERP XML files to Power BI . Can some please recommend us, if there is any connector or third party tool which can help us.1.9KViews0likes3CommentsReport builder connection to Access will not work once published
I built a paginated report that has an MS Access database as its source. When I publish the report I cannot acccess it. I get the following error: Unable to render paginated report There was an error contacting an underlying data source. Manage your credentials or gateway settings on the management page. Please verify that the data source is available, your credentials are correct and that your gateway settings are valid. Timestamp: 2023-05-10T10:36:55.812Z Root activity ID: fc2227fa-c74d-8a31-3114-8b5d28415c8c Session ID: 0000918024c24e01ad3df76a4cf95d2a Tenant ID: 78cfdb8f-c5d8-447a-bd00-4a88beced94a Cluster: https://wabi-us-north-central-g-primary-redirect.analysis.windows.net/ Report ID: d719889b-76b3-4372-8959-2166384855a5 ReportViewerVersion: 2023.5.1.704 What is the best way to connect to an Access database?515Views0likes1CommentGateway invalid Credentials
Hello to everyone, It has been 2 weeks now that i get the following error and i did not make any changes (the scheduled refresh was working 2 months in a row). Data source error: {"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the File source are invalid. (Source at \\\\eu962114-ger\\ger_data$\\pbi-logistics newdev\\frr forecast\\fnrforecastaccuracy.xlsx.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"File"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"\\\\eu962114-ger\\GER_Data$\\PBI-Logistics NewDev\\FrR Forecast\\FnRForecastAccuracy.xlsx"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"File\",\"path\":\"\\\\\\\\eu962114-ger\\\\GER_Data$\\\\PBI-Logistics NewDev\\\\FrR Forecast\\\\FnRForecastAccuracy.xlsx\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: 99Results. Cluster URI: WABI-NORTH-EUROPE-K-PRIMARY-redirect.analysis.windows.net Activity ID: f71198f8-4cae-4ad6-aee8-b2fc06362623 Request ID: 259fd469-1cf3-afa6-ce77-b54aa5c67717 Time: 2023-03-22 12:35:40Z Could help me find a solution?3.6KViews0likes1CommentOn-premise Power BI Report Server to On-premise SAP HANA SSO / SAML connection
Dears, we have an On-premise Power BI Report Server and On-premise SAP HANA. Would anyone guide to establish a connection with proper SSO / SAML configuration ? Kindly note: we have searched already and most of the links lead to Power BI cloud / service which is not our scenario. Thank you in advance.940Views0likes1CommentConfigure Data Gateway to Hosted Environment
Has anyone setup a data gateway with a hosted environment with an oracle database? Were their any issues that you encounted during the setup? Afterwards were you successfully able to import the data into a dataset and onto a dashboard, etc.?Solved805Views0likes2CommentsReporting server doesn`t connect to rb-superopl.emea.bosch.com...
Hello everybody does anybody know how I can connect Report server with rb-superopl.emea.bosch.com.... With publisher we could connect with our windows user, but in the report server we got following failure message: siehe attachment. Greetings Barbara1.4KViews0likes3Comments