Power BI Report builder | Matrix displays empty row on top with totals
Hi, I'm not sure if this is the right section of the forum, as I'm using the Report Builder from an existing report published in the Power BI service. In the original query in Power BI Desktop, my tables work just fine. However, in the Power BI report builder, I get an extra empty row for each level of the matrix with my total values as a value of the field. When I try to add functions to calculate the totals at the bottom of the table, my values are not correct because the formula picks up the values in those empty rows too. In the example above, the first row has empty values for Tenant ID and Batch, and the values of the columns are really the totals. So, if I sum the fields values for "Onboarded" in the total row, I get 66, while the correct value should be 33. How do I exclude that first empty row? It's really confusing... Thanks in advance! ~AlienvolmUpload Multiple Files on Power Bi Report Server
We have a requirement to move around 50+ Reports from One Power Bi Report Server Instance to another so i would like to know is there any option so that we can bulk upload more than one file on the report server ? As per my understanding the upload file option in the report server only allows the upload one file at once and using Power BI Desktop also we can only upload one file so i would like to know any way by which we can upload more than one file on the report server.
Troubleshoot Very Slow Paginated Reports
We primarily use the PBI Service, however we have a couple onprem reports hosted in Power BI Report Server. To consolidate, we've moved our SSRS reports to be hosted on the PBIRS Server however performance for the same reports on PBIRS vs SSRS is worse by a factor of about 10x. PBIRS is running Sept 2022, and reports all come off our onprem warehouse so no gateway. It's also not hardware as the 2 servers are configured the same, same subnet, same service account... I'm using one of our simplest reports which is a select of about 600 rows from a user table - selects the whole table no WHERE clause. On SSRS it might take 2-4 seconds to render, on PBIRS it takes upwards of a minute. There appears to be 0 load on the PBIRS server or the database server. I don't know if it has to spin up engines or instantiate connections or what, but there is something very different in the processing between the 2. I've looked at SQL Server logs, windows event logs...but don't see anything. Are there any logs that will have the whole flow from the request hitting the RS, or can I enable some verbose logging? I'm just not sure where to go next.
Matrix colors not preserved after publishing a report to on-premises Report Server
Hello, Using Power BI Report Server (on-premises). I am facing the following issue: I use a standard matrix visual, the one that comes by default. Column and row Totals background were set as blue in design time, in Power BI Desktop: After publishing to our on-premises server, they constantly show in black even though I explicitly set a blue color: Please advise, Regards.
View a Power BI report on Power BI Report Server from a different domain
We have Power BI Report Server installed on a server (Version1.14.8179.37378(May 2022)). A report has been uploaded to this instance which is viewed in an iFrame of another application. The instance of Power BI has been installed on the domain ABC. When users log on to the ABC domain they are able to view the report in the iFrame. There is a requirement that users in a different domain named DEF be able to log on to the application and view the report. However, when they tried it fails. We are able to successfuly add a user in the DEF domain to the browser role in the instance of Power BI Report Server. However, when that person goes to the URL of the report, she is unable to view the report. So, Power BI Report Server is installed on the ABC domain. It is able to authenticate users on the DEF domain. What would we have to do so that users on the DEF domain can view the report?Report Server: How to publish a report to the internet?
Hello all, d_gosbell Currently I am using Power BI Report Server (September 2021) - which is the on-premise version of Power BI. I used Power BI Desktop - Optimized for report server to save my report. I can view it on the Report Server Web Portal at the moment. How do I publish my report on the Power BI Report Server to the internet? Can someone please send a step by step guide on how to acheive this? Kindly require support on the matter. Thanks in advance!
