Optional & Multi-Select Paginated Reports Query Parameters with Analysis Services Data Source
Hello Power BI community! I need help with parameters and paginated reports. I want to generate paginated reports from within Power BI using the Paginated Report Visual as the container. I'm using Analysis Services as a data source and need to employ DAX for the datasource. Since "report filter parameters" are slow, I prefer using "query parameters" for faster performance. My goal is to use Power BI slicers to send multi-select data and optional slicers from the Power BI page. This way, if a user doesn't make a selection, it defaults to "All." I'm struggling to find clear information or tutorials on implementing this technique. If you know of any tutorials creating parameters using DAX, please share. I appreciate any assistance. It seems that while Power BI incorporates SSRS, connecting them via parameters isn't as seamless as expected. Thanks!
SUMPRODUCT in Paginated Report using MS Report Builder
Using the Paginated Report in MS Report Builder, I'm trying to calculate a SUMPRODUCT for a column Total. The SUMPRODUCT that I need to calculate is: SUMPRODUCT(Start FTP, Previous Balance, Total Previous Balance) or SUMPRODUCT(C2:C3, B2:B3) / B4 A B C 1 2 3 4sidebar that grows vertically (Align containers)
I am working on a power BI Paginated Report in Report builder: I have got 2 Rectanges (containers). The main container is in yellow. It contains 3 textboxes, a table and the red container. then there is the red container (which is inside the yellow container) that contains an image and a textbox in purple. I want the red container to be aligned with the yellow one. It needs to grow vertically and dynamically depending on the table and the textboxes sizes. As you can see circled in the image below the red container does not grow vertically and dynamically (it needs to fill the space circled in blue) alongside the table and textboxes with expressions. how can I make the red container the same height as the yellow one dynamically ? Basically my main goal for the red container is to act like a side bar. Keep in mind that I am using multiple datasets and I will use multiple tables. Thank you for your help in advance.
RLS members (>100 email addresses) maintaining
Hi, I have using Roles using USERNAMEPRINCIPAL() on my desktop. I would filter data based on that and display for users just own data on the report. Then in the online service, where we add email addresses (Row-Level Security/Members) to the roles you defined in desktop, is there a way to add more than 100 people in one go? Now I'm adding one-by-one, which is tedious job. Is it possible to add/refresh member email adresses dinamically? RLS is a perfect solution for this, I have jut a problem to maintain member addresses on the server. Is there any other way/tip?
