PowerBI Error Message if Directquery
Hello, i installed PowerBI RS some minutes ago to try Direct Query. If I connect a PowerBI Dashboard with a DataSource for example a Server then I get the following error if I want to use this Dashboard. " Es konnte keine Verbindung mit dem Analysis Services-Server hergestellt werden. Stellen Sie sicher, dass Sie die Verbindungszeichenfolge richtig eingegeben haben. Anforderungs-ID7dbe5c07-c7e8-ec48-fd0c-4b17184d7d2f ZeitFri Oct 31 2025 14:49:01 GMT+0100 (Mitteleuropäische Normalzeit) Dienstversion/powerbi/libs " Can someone help?Updating Schedule refresh for Power BI Report
Hi, As we know, Schedule refresh for Power BI report could be set manually on the UI. If we are trying to automate the setup of schedule refresh on a report instead of manually entering it, what are the optins we have - 1) Can the meta data tables ( Catalog, Subscriptions, Schedule, ReportSchedule) be used to stage entries into these tables and the schedule refresh shows up on the UI fo the report? 2) Any REST API code that could be used in a power shell script to place/update the schedule information on the report? Was able to extract Schedule from a Power BI report on Test report server to a JSOn file. Now need this information to be read from JSON file and updated to the report on Prod report sever? - REST API can do it? 3) If first and second options are not feasible, what other options are available? Also, why does this mesage popup under "Schedule Refresh" section ?
PowerBI, Windows Auth and Entra ID
I am looking at enabling Entra authentication for an on-premise PowerBI report server. Can PBIRS simultaneously support both integrated Windows authentication and Entra auth? i.e., will domain-connected users who currently authenticate with SSO be prompted to authenticate via Entra? Or will they continue to have access as they do today (no prompt) and only non-domain connected users would get the Entra login prompt?Power Bi Report Builder(Paginated Report) Dynamic
Hi! good day everyone, i have question, this is the environment : * Power bi Report builder * Datasource is from semantic model * to create dataset is with queries dax i am trying to créate a report in power bi report builder, with this sections: * header * body ( with 3 page columns ) * footer the data is about students, and it must be displayed by year, one year have at least 100 records these records are * header (the generic data student ) * body ( the body is the data subject, and it has to be displayed in 3 columns page) * footer Example At this point, i am able to run one year that has only one student and get header and details but when the year has more one record, i don know how to run massive I want to make a dynamic header for each studentId page, and details Can any one please help me on this? Thanks in advance
ReportServer database procedures are continuously getting recreated in scale-out deployment
Hi, In a scale-out setup with two nodes, we started by having a standalone instance with May 2024 version, joined another one with Jan 2025 version, and started to have some transient issues (see related issue below). We followed the recommendation and brought both instances to Jan 2025 version by upgrading the first one too. They are now both at: Version1.22.9153.7886 (January 2025). We are still encountering some transient errors with the message "An error occured within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError)" BUT we caught an instance where the detail message was: "Could not find stored procedure 'GetSnapshotPromotedInfo'". We immediately asked the DBAs to check for this procedure, and it existed in the RS database, but its created_date was very recent (few minutes behind) and almost half an hour after we encountered the above message. Upon further checks it seems that this procedure is re-created regularly as created_date changes constantly. We then checked another separate instance that we have for a few years now, and on that one the created_date is very old, even though the instance is heavily used (over 20k executions daily). We believe that recreating these objects is actually not a normal behavior, and it might have something to do with the scale-out. 1. It's possible that the ReportServer database got somehow messed up because we had two versions of PBI RS connected to it? 2. What would be the best course of action to repair it without reinstall? note: there were also other stored procedures that were initially not found which are most likely in the same situation - with this particular one we dug deeper to check it. Thank you!
