Report Builder Paginated report w/ 2 datasets sharing common Parameters issue
I have a Paginated Report (I am using a tabular model from our analysis server) question as I have 2 datasets joined by a common Parameter which is the DateColumn MonthYear- I have these referenced inside both datasets like so: (dataset1 uses both parameters for filtering but I want dataset2 to only use the date filter) Dataset1 has YearMonth and PhysicianOrg parameters but Dataset2 only has YearMonth as we do not need the PhysicianOrg parameter for Dataset2. I have a total of 4 datasets from the same source. Dataset1 will be filtered by both Physician Organization and Date (monthly reporting) and DataSet2 will only be filtered by YearMonth. I created 2 new tables for both Parameters (YearMonth and PhysicianOrg). Dataset2 only references the yearMonth parameter which is what I want as I wish to COMPARE the OVERALL score to the score which will be filtered by both YEARMONTH and PHYSICIANORG. When I add a new table and reference dataset2 along with dataset1 in one table it does work. I tested this expression from Dataset2: =Lookup(Fields!YearMonth.Value, Fields!YearMonth.Value, Fields!ID_AllowedPMPMYTD_.Value, "DataSet2") AND =SUM(Lookup(Fields!YearMonth.Value, Fields!YearMonth.Value, Fields!AllowedPMPMYTD_2.Value, "DataSet2")) and it does NOT WORK. (the numbers are not matching the excel formula which is =IFERROR(CUBEVALUE("Cube",GM,CubeMeasures!$D$25,CurrentMonth),0). (the current month is hardcoded and referenced I tried this expression inside the same table and referenced Dataset2 but that did not work. I am trying to match an excel formula report which uses HFPN overall is just AllowedPMPMYTD =CUBEMEMBER("Cube","[Measures].[AllowedPMPMYTD]") (it filters by month using How is this matched in Report Builder??? Do I need to use a DAX variation of CURRENT MONTH? I use the formula below sliced by yearmonth (SQL via Tabular Model) in Report Builder: The question is how do I show both results from 2 datasets in one paginated report? I just need one column with the same expression to filter differently: The Rate Column Filters by both parameters and the HFPN column filters by yearmonth column. Any suggestions? I created dataset2 just for HPFPN overall which I am currently hard coding until I can work this relatively simple problem out. EVALUATE SUMMARIZECOLUMNS('Providers'[PCPLocation], 'Providers'[PhysicianOrganization],'DateDim'[Year],'DateDim'[MonthNameAbbreviation],'DateDim'[YearMonth], FILTER(VALUES('Providers'[PhysicianOrganization]), 'Providers'[PhysicianOrganization] = @PhysicianOrganization),FILTER(VALUES('DateDim'[YearMonth]), ('DateDim'[YearMonth] =@YearMonth)), FILTER(VALUES('Patients'[Populations]), ('Patients'[Populations] = "GM")), "UniquePatients", [UniquePatients], "TotalCostYTD",
hide a text box if a Tablix shows "NoRowsMessage" or has not rows in PBI report builder
Hi, In Power Bi report builder, I need to hide a text box if a tablix shows "NoRowsMessage" or does not have any rows. I've tried different options,none of them worked. I pasted them into Properties->Visibility->Hidden->Expression =IIF(CountRows("DataSet1") > 0, False, True) =IIF(CountRows(Fields!Title.Value, "DataSet1") < 0, True, False) Please tell me a solution.
Reports Not Loading in Production Environment
I used a Web API for a Power BI report, published it, and deployed it in our Production setup. However, among 47 reports, only two face an 'InvalidOrMalformedSemanticQueryDefinition' error. These reports act inconsistently, sometimes loading data and visuals and sometimes not thus giving an error, especially when refreshed or opened. This inconsistency in loading poses a challenge in ensuring consistent accessibility and functionality for these particular reports. Reports are working fine in Power BI Desktop and Power BI Service. If somebody can help on this issue, I'd greatly appreciate it.
Power BI Report Server lock Publish button
Hello all, With the new update of the Power BI Report Server there is the possibility to migrate the reports to the cloud with one click on the button "Publish". Is there a possibility to lock this button. We want to prevent that reports are thus migrated to the cloud and thus the data also ends up in the cloud. Thank you
Power BI Datasets and Gateway
I'm having a big problem with my datasets and the gateway I had problems with my last gateways connectors So I decided to delete all and start all again But know Power BI Server isn't connecting to my Gateways I have two gateways (standard and personal) both are online but Power BI is showing that non gateway is installed or online Why is this happening?
