powerbirs

5 Topics

Power Bi RS scheduler refresh error
we face attched error after apply last update from PBIRS and renew SSL certificate and when open in edge error is "An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database."}} reports/api/v2.0/schedules and when refresh page see schedule created any advice about the reason thanks
Anonymous
1 year ago Place Report Server
617Views
0likes
1Comment
PowerBi RS Sharepoint Data Refresh
Hi All, i' ve a PowerBi Report published in SSRS. The powerbi Report has a data scource that is a Sharepoint Online list. I need to schedule data refresh in PowerBi 1 time per Day, but i've an error. In the Data Source Options, i can't choose the credential as "Microsoft login", that is required in my report. How can i schedule data refresh based on Sharepoint Online List? Thanks in advance,
Solved
Anonymous
3 years ago Place Report Server
652Views
0likes
1Comment
PBIRS Jan 2021: Error: "We couldn't connect to the Analysis Services server"
I have a report which runs on 2 out of 3 "identical servers". Each Server is Win2012R2, Running SQL 2016 13.0.5865.1 and PBIRS 1.10.7737.32652 The error message seems generic and unhelpful. We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.: SSAS/OLAP is not being used at all. The report is using Basic Authentication to make a direct query to SQL on the same server. The query and credentials have been tested and run fine on all 3 servers. RS log shows more detail: : 2021-05-13 08:52:02.2894|ERROR|69|PBI.Win.DataExtensionException|ExceptionType:Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException;DataExtensionErrorDetails:Details: Message=Failed to get CSDL., HResult=0x80004005, ErrorCode=QuerySystemError, Language=en-US, ProviderErrorCode=0xC1070000, ProviderErrorMessage=[2663DD5278984E7565A2F88E29150C3F45B0F0A259F58B6FD892970FE6450AA7], ProviderGenericMessage=[COM error: COM error.], ErrorSource=PowerBI, ErrorSourceOrigin=MsolapWrapper, OnPremErrorCode=, InnerErrorDetails=[Type=MsolapWrapper.MsolapWrapperException, Message=Failure encountered while getting schema];stackTrace: at Microsoft.PowerBI.DataExtension.Msolap.SchemaCommand.GetModelMetadata(String catalogName, String perspectiveName, String supportedVersion) at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.ExecuteSchemaCommand[T](ExploreHostDataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, IConnectionFactory connectionFactory, IConnectionUserImpersonator connectionUserImpersonator, QueryExecutionOptionsBase queryExecutionOptions, ITelemetryService telemetryService, Func`2 action, String failTelemetryMessage, ServiceErrorStatusCode statusCode, ExploreBaseEvent exploreEvent);message:GetModelMetadata;| RequestID = dc96695b-4835-a4fe-84fc-fdb32313db5b ClientSessionID = 34bde5db-4898-1197-fb8b-0c9756551a1a 2021-05-13 08:52:02.2894|ERROR|69|PBI.Win.ReportingServicesHostTrace|type:Error;message:library:Throwing Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: , Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'b8ddd68c-e96b-4e4c-be7f-3b156adb72f1_-615167943'. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException: Failed to get CSDL. ---> MsolapWrapper.MsolapWrapperException: Failure encountered while getting schema at MsolapWrapper.Utils.ThrowErrorIfHrFailed(Int32 hr, String message) at MsolapWrapper.CDbSchemaRowsetWrapper.ExecuteSchemaRowset(Guid schema, Object[] restrictions, PropertySetCollection propSets) at MsolapWrapper.SchemaCommand.ExecuteReader(Guid schema, Object[] restrictions) at MsolapWrapper.SchemaCommand.GetModelMetadata(Object[] restrictions) at Microsoft.PowerBI.DataExtension.Msolap.SchemaCommand.GetModelMetadata(String catalogName, String perspectiveName, String supportedVersion) --- End of inner exception stack trace --- at Microsoft.PowerBI.DataExtension.Msolap.SchemaCommand.GetModelMetadata(String catalogName, String perspectiveName, String supportedVersion) at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.ExecuteSchemaCommand[T](ExploreHostDataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, IConnectionFactory connectionFactory, IConnectionUserImpersonator connectionUserImpersonator, QueryExecutionOptionsBase queryExecutionOptions, ITelemetryService telemetryService, Func`2 action, String failTelemetryMessage, ServiceErrorStatusCode statusCode, ExploreBaseEvent exploreEvent) --- End of inner exception stack trace ---;;| RequestID = dc96695b-4835-a4fe-84fc-fdb32313db5b ClientSessionID = 34bde5db-4898-1197-fb8b-0c9756551a1a 2021-05-13 08:52:02.2894|ERROR|100|Failure in conceptualschema| RequestID = dc96695b-4835-a4fe-84fc-fdb32313db5b ClientSessionID = 34bde5db-4898-1197-fb8b-0c9756551a1a Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'b8ddd68c-e96b-4e4c-be7f-3b156adb72f1_-615167943'. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException: Failed to get CSDL. ---> MsolapWrapper.MsolapWrapperException: Failure encountered while getting schema 2021-05-13 08:52:02.2894|INFO|50|Sending response. Response code DOMAIN\prm 200, Elapsed time 0:00:00.0641639| RequestID = dc96695b-4835-a4fe-84fc-fdb32313db5b ClientSessionID = 34bde5db-4898-1197-fb8b-0c9756551a1a 2021-05-13 08:52:02.3519|INFO|94|Received request GET /libs/styles/InfoNav-Sprites.png| RequestID = s_e58e725f-a544-4fb8-b97c-1d3dc872e85a 2021-05-13 08:52:02.3988|INFO|94|Received request POST /api/explore/reports/b8ddd68c-e96b-4e4c-be7f-3b156adb72f1/conceptualschema| RequestID = 4bb937bc-b2d3-8dc5-2817-4e3a03b60580 ClientSessionID = 34bde5db-4898-1197-fb8b-0c9756551a1a 2021-05-13 08:52:02.4300|ERROR|107|Failure in conceptualschema| RequestID = 4bb937bc-b2d3-8dc5-2817-4e3a03b60580 ClientSessionID = 34bde5db-4898-1197-fb8b-0c9756551a1a Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'b8ddd68c-e96b-4e4c-be7f-3b156adb72f1_-615167943'. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException: Failed to get CSDL. ---> MsolapWrapper.MsolapWrapperException: Failure encountered while getting schema 2021-05-13 08:52:02.4300|INFO|107|Sending response. Response code DOMAIN\prm 200, Elapsed time 0:00:00.0238187| RequestID = 4bb937bc-b2d3-8dc5-2817-4e3a03b60580 ClientSessionID = 34bde5db-4898-1197-fb8b-0c9756551a1a 2021-05-13 08:52:14.9294|INFO|109|Started clean up of embedded models 2021-05-13 08:52:14.9294|INFO|109|Finished clean up of 0 embedded models Why does this run on 2 servers but not the 3rd? Why is it trying to use MSOLAP? I have also posted on StackOverflow Any suggestions or ideas would be greatly apopreciated. Edit: To explain: We have 3 servers to seperate Development, Testing and Production. We have a processes for UAT, version and change control. We spend hundreds of hours developing and testing content. So it is incredibly frustrating to have a report that has been thoroughly tested and accepted by the business and we can't get it to run in Live. Yet everything else works.
Solved
kiwipeet
5 years ago Place Report Server
7.3KViews
0likes
8Comments
Access to PowerBI Report Server URL asking for password
Hello, I need some help. I have reports published on the PowerBI Report Server, but every access I make through the URL it asks for the server user's login and password. I also can't publish my local machine on the server on another machine, does anyone have a solution?
lferrareto
5 years ago Place Report Server
1.5KViews
0likes
2Comments
Passing slicer selected values to PowerBI report .rdl not being retained
I have a powerbi report that has a matrix, so I've added in a button that takes the end user to an identical .rdl that will export in a more "friendly" format. I've had to use the Azure link that generates when the report is shared to get this link to work since the end users are outside of my organization, however in doing this, it appears the URL gets reformatted somewhere in between the click and report generation and the values selected within the slicers of the powerbi are not retained the URL passed to the .rdl. Any ideas on how to get this to stay so that the report will auto generate based on the slicers chosen? powerbi URL: var __baseURL1 = "https://azure.microsoft.com/email/?destination=https%3A%2F%2Fapp.powerbi.com%2FMobileRedirect.html%3Faction%3DOpenRdlReport%26reportObjectId%3Dreportidisretainedinurlbelow%26ctid%3Dthisissomethingthatdoesnotshowupbelow%26groupObjectId%3Dthisissomethingthatdoesnotshowupbelow%26OpenAppFromWindowsPCAndTablet%3Dfalse%26emailSource%3DReportInvitation&p=differentreportinvitationthanbelow" var __baseURL2 = __baseURL1 & "?rs:Embed=true&rp:YrQtr=" & SelectedTimePeriod & "&rp:O=" & SelectedO & "&rp:C=" & SelectedC & "&rp:P=" & SelectedP & "&rp:D=" & SelectedD & "&rp:T=" & SelectedT & "&rp:AnStart=" & SelectedAnStart & "&rp:AnEnd=" & SelectedAnEnd & "&rp:DStart=" & SelectedDStart & "&rp:DEnd=" & SelectedDEnd & "&rdl:format=EXCELOPENXML" RETURN __baseURL2 this is the URL it changes to: https://app.powerbi.com/groups/cc05b225-b719-4c9d-a42a-baa017b11c1c/rdlreports/sameasabove?openReportSource=ReportInvitation&ctid=differentthanabove
ashleytanoe
6 years ago Place Report Server
703Views
0likes
1Comment