PERFORMANCE ISSUES IN PAGINTED REPORT BUILDER
We have a materialized view in Databricks with about 1.5 million rows and 80+ columns. On top of that, I’ve created a semantic model in Power BI, and a paginated report that shows essentially all 80+ columns (so it’s returning the full 1.5 million rows). The report also has around 24 filters/parameters. Because of this combination (large dataset + many columns + many filters), the paginated report is taking a long time to load. The main dataset is generated using the Query Designer, which produces a large: `EVALUATE SUMMARIZECOLUMNS(...)` So far, to improve performance I have: 1. **Created lookup tables for parameter datasets** Instead of retrieving dropdown values from the large flattened dataset, I created lookup tables and updated parameter datasets to use these tables. In the Databricks view we have 3 date columns: **D1, D2, D3**. In the Power BI semantic model I’ve joined these to `dim_date`. In the paginated report I want to expose 6 date parameters: **StartD1, EndD1, StartD2, EndD2, StartD3, EndD3**. I have three main questions: **Q1. How should I handle these 6 date parameters in the main dataset?** Each date column has its own start/end range; I’d like an approach that is reasonable to maintain. **Q2. Is the current approach (one big flattened table from the view) the right one?** We actually started with a star schema in the Power BI semantic model and then moved to a single flattened view, as suggested by a senior data engineer. The issue was that many of the 80+ columns required calculated columns and a lot of transformations, so we pushed all of that logic into the Databricks view instead. **Q3. How else can I improve performance?** Right now the paginated report is effectively selecting all rows and almost all columns, with 24 filters on top. I’m looking for design patterns or best practices (e.g. alternative modelling, pre‑aggregation, splitting datasets, etc.) that would make this scenario perform better. Any guidance or examples would be really appreciated.
Display Images In Report Bulder using PowerBI dataset
Hello, My goal is the following: I have to display images, stored in PowerBI dataset into SSRS Report. The images were converted to Base 64 format and they are displaying correctly in PowerBI desktop. When I try to load them in Report Builder it's not possible and I receive error. This is what I've tried so far: - First - I select insert image --> the value of the Image with base 64 format. The source is "Database" and MIME type "image/jpeg" - Second - the same thing but instead of the base 64 image I select the text value of the image. Both give no result. I also tried the solutions from this post but they didn't work for me -->https://community.powerbi.com/t5/Report-Server/How-to-display-Base-64-PNG-images-from-a-database/m-p/1177424 Can you plese help with this? Regards, VassilHeader (distinct value) to be displayed in Paginated Report (Report Builder)
Hi, I need to display some name & id as a header. We are allowing only one name to select from filter, when we display as header using text box or table or list, we are getting same values duplicated in multiple rows though only row to be expected. Is there a way on this Paginated Report to display only one value as however I try same value getting repeated in multiple rows. Please let me know if you need more details. Its getting repeated like as in snap below: To be displayed like: Thanks NagNo Fields in Dataset
Hello, I've connected my Report Builder to a Dataset in my premium workspace. It is listed as a data source. The Table Wizard requires connection to a Dataset, so when I try to make a dataset out of this source it doesn't give me any fields to pick from. It's like the data source has no fields at all. I loaded this to PBI Service from PBI Desktop where I've made various reports with it. Any idea why I can't get the fields to show up?
Page break for column groups - paginated reports in Power BI Report Builder
Hi! I am creating a report with some year/month column groups (as below). I would like to have a page break for every year group (not month group) in Power BI report builder. I am able to do so with the row groups, but can't seem to do it with the column groups. Any ideas? Thanks!
Dynamic Paginated Report in Power BI Report Builder
Hello everyone. Till now, I have worked only with Power BI Desktop application. However, now, I need to create a paginated report that will get delivered to users' mailbox automatically everyday. I searched around a little bit and discovered Power BI Report Builder tool. However, I find it extremely unintuitive (compared to PBI Desktop) and the documentation is not as clear as that for PBI Desktop. Basically, I am fetching data which looks like below (from SQL Server) - What I want to do is have a paginated report created which will have X number of pages in it, where X = no. of distinct BUs found in the records. Each page in the report should have the BU name mentioned at the top. The first page should show the Total Aggregated Amount (ALL BUs combined). I plan on showing a line chart on each page. So, for my dataset shown above, the report should contain 4 pages - 1. Total, 2. EX1, 3. EX2 and 4. EX3. Everyday, at a certain time, the report generation process should start and create a PDF of this report and deliever to the users' mailbox. What I wonder is - are all of these things possible with Power BI Report Builder ? If so, could someone guide me through the process of report design. I have tried following a couple of articles I found on the web (links shared below) but no luck getting things the way I want 'em. Any help is appreciated. Article1 Article2 d_gosbell josef78 lbendlin Thanks in advacne, Nachiket P.
