need help paginated report
18 TopicsTenant Not authorized For Cluster
In Power BI Report Builder i am trying to connect to a semantic model in the Power BI Service. I have a Pro license and I have made dozens of Paginated Reports with data sourced from a semantic model in the Power BI Service. This error has become a consistant issue that prevents me from doing anything in this app. Can anyone give me some more information on this error? How can I pinpoint the issue? How can I resolve this? Microsoft.ReportDesigner.ErrorHandling.PowerBIHttpRequestException: Tenant not authorized for cluster Request error: Id: 31fa8149-5e45-4765-acac-3964c1ab68c7, Status code: Forbidden, Timestamp: 9/2/2025 5:18:17 PM +00:00, ErrorCode: InvalidRequest, Detail: An unknown error was encountered. Please try again. at Microsoft.ReportDesigner.Ribbon.Utils.ServiceClientUtils.<GetMyWorkspaceId>d__10.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.ReportDesigner.Ribbon.PowerBIClientManager.<GetMyWorkspaceId>d__89.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.ReportDesigner.BrowsePbiViewModel.<<Initialize>b__138_0>d.MoveNext()Solved3.3KViews0likes6Comments“Some parameters do not have valid values” Error for power BI Paginated Report
I have a Paginated Report with a subscription which has parameters with list of customers, products where I can select certain customers and products and see the sales for it. I’ve selected a set of customers and products from their respective parameter drop down and got a table with the selected customers, product and their total sales, I’ve created a paginated report subscription for the same and it works fine. Then a customer that I had selected to display in my report subscription was marked as inactive in the source database and ceise to exist in the sematic model. When I ran my subscription or when the subscription ran automatically I got an error where it said “Some parameters do not have valid values”. One simple fix to this is to edit my Subscription and unselect the Customer that was removed from my semantic model. If I do this the subscription works fine shows the remaining checked customers in the attachment. But is there a way for power bi to be less strict, where if customers no longer exists in the semantic model, then my Subscription shouldnt stop/break and automatically send the data of the existing customers that are checked and present in my semantic model.Solved2.4KViews0likes4CommentsIsNothing is not working for me
Hi, I am using below expression: It is not working for me. When I have value in M3_Gross_Sales_Contract_Entity.Value, it is showing % value. I am also using below expression: IIF(SUM(Fields!M3_Gross_Sales_Contract_Entity.Value) = 0 AND Fields!M3_Gross_Sales_Contract_Entity.Value="", 1, (Sum(Fields!M4_Gross_Sales_Contract_Entity.Value, "Main")-SUM(Fields!M3_Gross_Sales_Contract_Entity.Value, "Main"))/SUM(Fields!M3_Gross_Sales_Contract_Entity.Value, "Main")) when I have value in M3_Gross_Sales_Contract_Entity field, it is showing %value , but when there is no value in: M3_Gross_Sales_Contract_Entity, it is showing #error Thanks, SandipSolved679Views0likes1CommentPage Break within a group
Dear Team, I have a simple Table with one group over 2 rows. My Problem now is that the export to pd creates a page break with a group. I've also tried to put it into a rectangle, but that didn't make no difference. Any idea? Thanks in advanceSolved5.1KViews0likes9CommentsReport Builder - Conditional Border for each text box in calendar format
Hi, I'm trying to replicate an existing feature on a report but I think my understanding of using parameters is hindering me from this replication. This feature creates a border around textboxes based on a condition. I actually wrote a lot of information that I'm afraid will just confuse folks, so i'll just ask and if its not clear still, I'd be happy to provide more information. Does anyone know how the variables "StartDay and "SwitchDays" would be designed in the report? I understand the logic of the expressions I just don't understand how to build this on the backend.1.3KViews0likes2CommentsGetting Server Error after selecting a value for a Parameter for Paginated Report in Report Server
Hello, I am getting this - Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500 as an error in Power Bi Report Server. I have created a paginated report in the Power Bi Report Builder. It has 5 parameters. The paginated report is working fine in Report Builder but after deploying it on the Report Server, the report is loaded but as soon as I select value for the first parameter, I am getting the 500 error mentioned above. Can anyone please help me with this? Thank you!459Views0likes0CommentsPaginated Report visual in Power BI throwing error after making first time selections.
Hi All, We have integrated Paginated Reports in Power BI report in paginated report visual and we are successful in doing that but the moment we make the first selections it throws an error 'An unexpected error occured' and when we navigate from other Power BI page to the page containing paginated report visual it starts rendering. Here is the screenshot of the error: Requesting the community to helping in this. Thanks & Regards, Sanjana804Views0likes3CommentsHow to show columns with no data in Report Builder?
Hi all, I have created a report in power bi desktop but I want to recreate the report as a paginated report in report builder. In power bi desktop, I can visualize my table with columns with no data (refer table below as an example). Company January February March April May A 124 242 165 But in the report builder, the table is like this (refer table below) Company January March April A 124 242 165 How do I make the columns with no data shown on report builder? Thanks in advance.613Views0likes1CommentHelp on language change issue of few columns in report builder
Hi Experts, Need help with the report builder, I am using Azure db as a data source for the paginated report,s and for 2 columns the data is showing in Chinese language but in the DB, it is reflecting correctly. Need help on this how to resolve the issue. Below find the attached screenshots for the db and report builder. Looking for your guidance. Thanks in advance. Best, HK369Views0likes0Comments