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, MichaelTMSL Alter Column Description
I am a noob in TMSL and I need your help. I am trying to add a description to the column in Power BI Services with a command: { "alter ": { "object": { "database": "dataset_test", "table": "005_SHIP_TO_LOCATIONS", "column":"CREATION_DATE" }, "column": { "name": "CREATION_DATE", "description":"This is the new description" } } } The error I get is: Unrecognized command: alter . Check path '['alter ']', line 2, position 13. Could you help me to make it work? This is Power BI Premium and I TMSL works for table name modification, but I can't figure out how to change the column description.
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?