"need help"
99 TopicsPower BI Report Server migration to new servers
We have three Power BI Report Server environments with each of these enviornments having a development, unit acceptance testing, and production setups. These environments were set up 8 years ago and are running on Windows Server 2016 (operating system) and SQL Server 2016 (for the report server databases). We are setting up new servers with Power BI Report Server to run on Windows Server 2025 and the Power BI Report Server database to run on SQL Server 2025 on Windows Server 2025. I have a couple of questions. The first and most basic is bringing the existing folders and reports to the new server. When cloning the original Power BI Report Server database (on SQL Sever 2016) to the new SQL Server 2025 is all that needs to be done? Do all the folders, reports, and security (on folders and reports) come over as well? I am just verifying. The second question is that we are thinking of consolidating all three environments into one consisting of DEV, UAT, and PROD. How would this be done. I see that one environment can be migrated over with the original database cloned to the new SQL Server 2025 instance (for example when we are doing DEV). How would the other 2 DEV environments be brought over to the new DEV environment. They each have their own database so the cannot be restored over the new database which has the PBIRS database from the first environment. For the other 2 DEV environments would we have to create the folder structures on the new DEV PBIRS and manually copy all the reports to it? Would we then have to duplicate the manually duplicate the permissions? We are looking for advice on whether to pursue one consolidated environment or build three new environments (each consisting of DEV, UAT, and PROD).Solved724Views0likes1CommentExperiencing random refresh errors after upgrading to Power BI RS January 2026
After we upgraded to January 2026 Report Server we started getting a random error with refresh schedules: “Failed to connect to AS” It can happen with any report, totally random, but when manually trigger the refresh it goes away. We did not change any settings and it never happened with previous RS versions. Please advise. RegardsSolved2.3KViews0likes9CommentsError related to data refresh in file: tmmdmodeltm.cpp
Hi, I have developed my report locally and refreshed data with no errors and also no errors has speen spotted anywhere in the report locally. Now im publishing the report to server. Tried to refresh the data and got an error related to data refresh in server. Has anyone faced similar problem? "An error has occurred. Several errors occured during data refresh. Please try again later or contact your administrator. [0] -1056964608: An unexpected error occurred (file 'tmmdmodeltm.cpp', line 7611, function 'MDModelTM::IsAttributeHierarchyQueryable'). [1] -1055129594: The current operation was cancelled because another operation in the transaction failed." We are using version: Version1.19.8779.19175(January 2024). Could someone help me out, what this file does or what this error-message refers to? Thanks!1.8KViews0likes2CommentsGuidance on Affordable Licensing Options for Power BI Report Server
Hello everyone, I am planning to move to Power BI Report Server and have been reviewing the associated pricing and licensing options. From what I have found so far, it appears that we need either a Premium capacity (minimum F64+) or SQL Server with Software Assurance, both of which seem prohibitively expensive for my use case. My objective is simply to set up an on-premises Power BI Report Server using our local infrastructure, without leveraging cloud services from Microsoft. Could someone guide me on whether there are any more cost-effective licensing options to use Power BI Report Server? Specifically: Is it possible to use Power BI Report Server with a cheaper subscription/license than Premium or SQL Server with SA? Are there licensing models or workarounds suitable for small to medium deployments that don’t require heavy cloud investment? Thanks in advance for your help.Solved10KViews0likes6CommentsPower BI Report Server don‘t support "Fields Parameter"
I create fields Parameter in a local file used Power BI Desktop, "fields Parameter" work's fine, but when I upload this file to my company's Power BI Report server, the fields Parameter didn't work... Power BI Report server not support " fields Parameter"? or my company's IT disable this function in the power BI report server?Solved2.7KViews0likes7CommentsI cannot connect sharepoint Data source in power bi report server on premises
I created a report that connects to Sharepoint, I can refresh it in the Power BI desktop normally, but when I try to configure the data source an error appears. I've tried several ways and it still hasn't worked. How can I fix this problem? Thank you.3.7KViews0likes17CommentsIssues Connecting Power BI to Spark (Livy + Kerberos) Behind Knox – Configuration Guidance Needed
Hello everyone, We are trying to connect Power BI Desktop to our internal Spark cluster but consistently run into authentication/connection issues. Before raising an official support ticket, I’d like to ask the community for advice on whether our configuration is correct or if there are common pitfalls we might be missing. Below are the architecture details and the parameters we are using. Architecture Spark Environment: Cloudera Private Cloud (on-premises) Gateway: Apache Knox (single access point) Spark Endpoint: Livy, exposed over HTTPS with Kerberos authentication Full URL: https://loadbalancer-coll.hadoop.xxxxx.it:8443/gateway/kerberos-lb/livy_for_spark3/v1 Authentication: Kerberos (corporate AD realm) and this is the error. Is there something we can do to try to see clearer error messages? any suggestion? thank s in advance MM1.2KViews0likes5CommentsCustom Security Roles in Power BI Report Server: Managing Server Without Content Access
Hi everyone! I'm working on implementing a specific security requirement in our Power BI Report Server. I need to create a custom security role where administrators can perform all their regular administrative tasks but cannot access or view the actual content of reports and files. Essentially, they should be able to: Manage server properties Handle security settings Manage jobs and schedules Configure data sources Set up subscriptions Move or Delete report But they should not be able to: View report content Access uploaded files See the data within reports I have already tried creating some custom roles, selecting among the various possibilities even the simple report management role. But this implicitly includes the ability to view the report itself. thank's in advance, MarcoSolved837Views0likes1CommentRLS Not Applying When Added/Saved from Power BI Report Server, but Works After Re-uploading it
Hello, Power BI Community, I am experiencing a critical issue with Row-Level Security (RLS) that seems to depend on the workflow used to apply it. When I configure RLS directly opening in edit mode from Power BI Reporting Service, the security rules do not take effect, even though they appear to be set up correctly. The security rules only become active after the report is downloaded and then re-published from the Desktop application. Has anyone else encountered this behavior? Is this a known issue, or am I missing a step when configuring RLS directly in the service? Any help or insight would be greatly appreciated. Thank youSolved1.4KViews0likes5Comments