Paginated report drill back from child to parent fail saying invalid params
Background : I have a Parent-child report combo which uses drilll thru functionality from Parent to child by passing few params. Parameter names and required fileds are mentioned appropriately and data types are also in sync. This report was working fine as expected few weeks back. Only change we made to this report was to remove few columns from tablix in parent report. Nothing touched in child report. Issue: Parent to child report drill thru works as expected. But when i try to go back to parent report by clicking inbuilt back functionality in paginated report on server, it fails sporadically giving an error saying "Some parameters do not have valid values. Values provided for Source_V_or_C that are not valid include . Values provided for Provider_Type that are not valid include . Values provided for Region that are not valid include . Values provided for EST that are not valid include . Values provided for Recon that are not valid include ." Defaulted param values to intake null/blank both in report and backend SQL, but still error persists. What/where do i need to check further to resolve this issue ? Parent params Parameters mapping Child report paramsVisualization Not working as needed with dax measure
Visualization drill down not showing. I can only drill through the non-compliant data and not the compliant ones. I have created a formula to check how much data is compliant and non-compliant. For example, if the customer has all the fields populated then he is compliant, so their details are missing from the Query1 table. If the member has a missing information, then he is non-compliant and will be available in the query table. Compliant Formula = DISTINCTCOUNT('DW v_Member'[MemberNum])/CALCULATE(DISTINCTCOUNT(Query1[MemberNum]),ALL(Query1)) Non-Compliant= 1- ( DISTINCTCOUNT('DW v_Member'[MemberNum])/CALCULATE(DISTINCTCOUNT(Query1[MemberNum]),ALL(Query1))) I have also created a calculated column in the member table to check if I can showcase both compliance and Non-compliance data but that is also not working Compliance Check = IF( COUNTROWS( FILTER( Query1, Query1[MemberNum] = 'DW v_Member'[MemberNum] ) ) > 0, "Non Compliant", "Compliant" ) Table information : Dw_Member: is a fact table with all customer information Branch is a fact table with all of company branches Date table Query 1 comprises of only those customers whose profile has a missing information for example date of birth or address etc. A customer can appear more than once if they have multiple information missing Donut chart appears correctly with compliant and non-compliant measures but all other measures are not getting drilled through see second chart
Is cross report drill through feature available in Power Bi Report Server
Hi there would this power bi cross report drill through feature available in Power Bi Report Server version as well. I could not find a way to do that, however it is working in Power bi Cloud version. Can you please advice. Thanks Syed
