We couldn't connect to the Analysis Services server. Make sure you've entered the connection string
We received the below error, when we open the dashborad. 1. the connection is tested sucessfully. 2. we upgraded the report server to the latest version, Version1.13.8054.40631(January 2022) 3. we also recreated analytics database. but still the same error message. when the dashborad try to pull the data from data cube. anyone is familar with this issue? Can you please help? your help is very appreicated. An unexpected error occurred An unexpected error occurred. Please try again later. Please try again later or contact support. If you contact support, please provide these details. We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.: Request ID: 06cee2e0-a499-114b-d23e-943699df8258 Time: Tue Jan 25 2022 16:09:46 GMT-0600 (Central Standard Time) Service version: /powerbi/libs
Paginated Report couldn't be export trough API
Hi, I have a paginated report connect in direct query to my SQL Server DB and to a Power BI Dataset. In the Power BI interface (website) all works fine. I can view my report and I can export it in all available format but when I want to export it trough the Power BI API, I received this error message : { "title": "Precondition Failed", "status": 412, "detail": "BUSINESS ERROR : Connection Error NotOpen: Connection open intermittent error while reading in Analysis Services, needs retry." } What does it mean ? Why is there a connection to Analysis Services ? Does it related to the Dataset ? FYI : We are using Power BI Premium with embeded capacities. There a lots of other paginated reports in the same workspace (but none with a dataset connection) and it works perfectly (so no rights problem.
Access denied at setting affinity for analysis services for report server power BI
Hello, Please when i try to set affinity for analysis services for report server power BI , there is an error appeared "the operation cannot be completed" access denied even I am administrator and have full privileges and this service NOT ALLOWED for UAC virtualization. any help please?
Deploy Power BI reports programatically with different SSAS connections per tenant
Hello, we develop and manage a software as a service platform using PowerBI embedded with Analysis Services in Microsoft Azure. Our CI/CD pipeline process provides an SQL database, Analysis Service Database, Web Application, PowerBi Embedded Workspace and multiple services per customer. Everything works fine for these steps. But the report deployment is still a manual process: - Open PowerBI Desktop - Open the report in question - Connect to the QA SSAS server and select the database for the customer for this specific deployment - Publish the report and select the PowerBI embedded workspace for that specific customer - Check visually that the report is working via Power BI Portal We would like to deploy the reports using PowerShell, but we could not find a way to change the connection string. We found multiple ways to change connection strings if no SSAS is involved, but we need SSAS. Any ideas how to solve this? Kind regards, Michael
Scheduled Refresh sometimes failing at "Streaming model to Analysis Server." / rsInternalError
Our Report Server started to develop some strange behavior with scheduled refreshes. Most of the time and at the moment these refreshes work correctly. But a few days back nearly no refreshes were working for more than a day. At times we even had some memory dumps. The errors we get in the “RSPowerBI….log” do look as following: The server has plenty of cpu and memory resources. Memory is never higher than 50%, cpu normal at 5-10% and peaks from time to time to 80-98% for the duration of a scheduled refresh (5-20s) msmdsrv.ini is at default settings msmdsrv.log shows no errors at all. Sometimes these errors also occur at night, when general workload on our system is at its lowest. We are at Version 15.0.1103.234 and now prepairing to update to 15.0.1104.239 By now I have run out of ideas to search for the source of the problem. Any suggestions where I should set my focus?Auto Refresh not work on Report server : [0] 0: Failed to connect to AS
Dear All, We met very stranger issue today, we can refresh our report from desktop manually but all our reports uploaded to report server was not able to refresh , details error: [0] 0: Failed to connect to AS, see below We tried a lot of steps like restart services, restart report server, repair/upgrade report server software but no one work, please help here, thank you very much ! An error has occurred. Data refresh failed. Please try again later or contact your administrator. Hide error details Show error details SessionID: 823bf9a1-3315-46ff-87fa-2860d0ef8117 [0] 0: Failed to connect to AS