Power BI Report Builder: group unrelated data
Goal: Hi, I am a bit unfamiliar with Power BI Report Builder/ Report Server. The goal is to have multiple datasets "grouped" by one multivalue parameter for a print out based on a selected multivalue parameter. Example - FarmHouse: I have multiple chickens from my chicken dataset who own multiple eggs on an egg table. They also store which henhouse they are from in a henhouse table. I would like to select multiple chickens and display a print out per chicken of their eggs and henhouses grouped per chicken. Contraints: Power Bi Datasets DAX Problem: I cannot have static inner members when grouping or encapsulating data that is unrelated. At base, data is unrelated within Report Builder. I have had some success using TREATAS to relate/filter results in a single example, but that is as far as I have come. Any suggestions, advice, resources, or questions are welcomed. Thank you!
Navigation to other pages in Power BI report builder
Hi Team , We are using Power BI Report builder for designing the paginated reports and finally we render it using the PDF format in our respective application . We have one specific requirement where we have one icon in the first page and on click of the same , it has to navigate to last section of the report . We tried using the bookmarks and since bookmarks doesnt render in the PDF format , we are not able to achieve this particular requirement . Hence request the team to suggest some solution through which we can achieve this particular requirement. Thanks for the support !! Best Regards, NitishPower Bi Report Builder | Limited Rows in Sub Reports
I am unsure if this is a limitation of the Power BI service or not, but any advice would be greatly appreciated. Synopsis: Using Power Bi Report Builder's sub-reports, we can select an account in a top-level report and pass parameters to display related information via sub-reports. If we load 42 or more rows in any one subreport, the workspace will refuse to display the data after it loads the rows. In this case, we made a simplified version that has only 1 sub report that contains 84 rows. The other row is the name of account on the Top-level report. Notes: The sub-report will load as long as there are less than 42 rows in each sub report in the Top-level Report. When there are more than 42 rows we are able to pull the data without issue from the backend. Thank you, - Ian
