report builder parameter

7 Topics

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.
Solved
swatig2904
1 month ago Place Report Server
Views
0likes
Comments
Performance Analyzer Query with 2 Parameters Run ok in DAX Studio, No Rows Found in Report Builder
Hi Guys, The below Query runs perfectly in DAX Studio, But returns no rows found in Report Builder. I am passing the report Parameters @Location and @Date as the query parameters What am I Possibly not doing? // DAX Query DEFINE VAR __DS0FilterTable = TREATAS({@Location}, 'CSLOCATION'[Location]) VAR __DS0FilterTable2 = FILTER( KEEPFILTERS(VALUES('Date Dim'[Date])), 'Date Dim'[YYYY/MM]= @Date) ) VAR __DS0Core = SUMMARIZECOLUMNS( 'CSPDETAILS'[Criteria], __DS0FilterTable, __DS0FilterTable2, "Score", 'RM'[Score], "Result", IGNORE('RM'[Result]), "Color", IGNORE('RM'[Color]) ) VAR __DS0PrimaryWindowed = TOPN(1001, __DS0Core, [Score], 0, 'CSPDETAILS'[Criteria], 1) EVALUATE __DS0PrimaryWindowed ORDER BY [Score] DESC, 'CSPDETAILS'[Criteria]
Solved
ugoriuko
4 years ago Place Report Server
Views
0likes
Comments
Report builder not accepting Date parameter as dd-mm-yyyy
Hi, hope someone can help me. I create a blank report with one parameter. I mark the parameter as datetime so that i can get a calendar. I have one field that references the parameter to see what it shows. If i select a date that is less than 12 days, it swops the month and date. So I guess it wants US date (MM-dd-yyyy) and I want UK (dd-MM-yyyy) My regional settings is (dd-MM-yyyy) I tried Report Localization Language as User language as well as en-GB I cant change anything on the Server I get this message after selecting a date on the calendar The value provided for the report parameter 'DateFrom' is not valid for its type. (rsReportParameterTypeMismatch) Any help would be much appreciated. PS I think it is a server setting, but I cant change anything there. Only way out for me would propably doing away with the calendar control and let people put in a text box what date they want.
MarlieHagen
4 years ago Place Report Server
Views
0likes
Comments
How to merge second row line to first row, in Paginated Report Builder
Hi I have the following setup Item No Category Direction1 Direction2 Value Value3 10006 Cat1 Pay 100 10006 Cat1 Rec 125 10007 Cat1 Pay 98.5 10007 Cat1 Rec 88.4 How can i show the values for the same item & Category in one row and not have them split into multiple rows. Any help will be appreciated.
Sai_Alkesh
4 years ago Place Report Server
Views
0likes
Comments
Power BI Report Builder Error
I have a report which I've transitioned to Power BI Report Builder from Report Builder 3.0. I've set everything up the same as it was on Report Builder 3.0 with the exclusion of a dsDefaultDates dataset. Originally they wanted it from the beginning of the previous month to the end of that month to now wanting it to cover the last years worth of new accounts. (See queries below) Unfortunately, when I hit "Run"...the first page shows up just fine, but then if you keep scrolling or hit the arrow to go to the next page; I get an error, "An error occurred during local reporting processing". Is there a log file somewhere which can provide me a bit more of a detailed reason as to the cause of the error? Report Builder 3.0 dsDefaultDates dataset query: select trunc(trunc(sysdate,'MM')-1,'MM') StartDate, trunc(sysdate,'MM')-1 StopDate from dual Power BI Report Builder dsDefaultDates dataset query: select trunc(sysdate)-366 StartDate, trunc(sysdate)-1 StopDate from dual; Power BI Report Builder Installed Version: 15.6.1628.2
Anonymous
5 years ago Place Report Server
Views
0likes
Comments
Combining OR & AND in multi-value parameters
Hi, I have 3 parameters in my report query. The system generated DAX is as follows. I need to modify below query such that either I enter a combination of [CNTR] & [CNTR_DT] or enter just enter [SUPP_LD_NO] as the parameter, leaving other two fields blank. EVALUATE SUMMARIZECOLUMNS('Data'[CNTR], 'Data'[CNTR_DT], 'Data'[SUPP_LD_NO], RSCustomDaxFilter(@DataCNTR,EqualToCondition,[Data].[CNTR],String), RSCustomDaxFilter(@DataCNTRDT,EqualToCondition,[Data].[CNTR_DT],DateTime), RSCustomDaxFilter(@DataSUPPLDNO,EqualToCondition,[Data].[SUPP_LD_NO],String)) Assuming I was clear with my requirement, please assist. Regards, Muralidhar
murali5431
5 years ago Place Report Server
Views
0likes
Comments
Power BI Report Builder Parameter (Oracle data Source)
Greetings, I am new to paginated reports and am trying to add parameters to my existing dataset in Report Builder. The dataset is populated via an Oracle DataSource, and I have not been able to figure out how to utilize parameters with this Data Source. Is it even possible? Any help would be appreciated.
Solved
oj606481
5 years ago Place Report Server
Views
0likes
Comments