Forum Discussion

ahmedshalabyy12's avatar
ahmedshalabyy12
Icon for Helper V rankHelper V
1 year ago
Solved

Paginated Reports

Hello,

 

I have table x   and made a relation with date table.

 

in power bi desktop the relation is working fine and i can filter the x table with the date column from date table

 

but in paginated report the paramteres not working 

Need Help
  • burakkaragoz's avatar
    burakkaragoz
    1 year ago

    Hi ahmedshalabyy12 ,

     

    This is a common issue when moving from Power BI Desktop to Paginated Reports. Even though the relationship works fine in the model, paginated reports don’t automatically inherit those relationships for parameter filtering.

    Here’s what you can try:

    1. Make sure your dataset includes the necessary joins: In paginated reports, you often need to explicitly define the relationship in your query (like using a JOIN between table x and the date table).

    2. Check your parameter setup: If you're using a date parameter, ensure that:

      • The parameter is linked to the correct dataset.
      • The dataset query uses the parameter in the WHERE clause (e.g., WHERE DateTable.Date = @YourDateParam).

    3. Use shared datasets carefully: If you're using a shared dataset from Power BI, it might not expose the relationships the same way as in Desktop. You might need to flatten the data or create a custom SQL query in the report builder.

    Let me know how your parameters are set up and I can help you tweak the query if needed.

    If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
    translation and formatting supported by AI

3 Replies

  • burakkaragoz's avatar
    burakkaragoz
    Icon for Super User rankSuper User
    1 year ago

    Hi ahmedshalabyy12 ,

     

    This is a common issue when moving from Power BI Desktop to Paginated Reports. Even though the relationship works fine in the model, paginated reports don’t automatically inherit those relationships for parameter filtering.

    Here’s what you can try:

    1. Make sure your dataset includes the necessary joins: In paginated reports, you often need to explicitly define the relationship in your query (like using a JOIN between table x and the date table).

    2. Check your parameter setup: If you're using a date parameter, ensure that:

      • The parameter is linked to the correct dataset.
      • The dataset query uses the parameter in the WHERE clause (e.g., WHERE DateTable.Date = @YourDateParam).

    3. Use shared datasets carefully: If you're using a shared dataset from Power BI, it might not expose the relationships the same way as in Desktop. You might need to flatten the data or create a custom SQL query in the report builder.

    Let me know how your parameters are set up and I can help you tweak the query if needed.

    If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
    translation and formatting supported by AI

    • ahmedshalabyy12's avatar
      ahmedshalabyy12
      Icon for Helper V rankHelper V
      1 year ago

      That's my query iam trying with chat gpt to solve it 
      but if you can help me with it 

      EVALUATE
      SUMMARIZECOLUMNS (
      'Csat'[agent_email],
      'Csat'[agent_name],
      'Csat'[artificial_ou],
      'Csat'[country_name],
      'Csat'[artificial_ou_region],
      'Csat'[badge],
      'Csat'[city_name],
      'Csat'[close_timestamp],
      'Csat'[count_agent_messages],
      'Csat'[create_timestamp],
      'Csat'[csat_issue_name],
      'Csat'[csat_issue_type],
      'Csat'[csat_rating],
      'Csat'[DSAT_category],
      'Csat'[DSAT_L2_category],
      'Csat'[fulfillment_type],
      'Csat'[global_product_name],
      'Csat'[has_appeasement],
      'Csat'[max_load_timestamp],
      'Csat'[mega_region],
      'Csat'[merchant_location_type],
      'Csat'[merchant_type],
      'Csat'[modality],
      'Csat'[ticket_url],
      'Csat'[net_handle_time_minutes],
      'Csat'[network_custom_language],
      'Csat'[network_custom_region],
      'Csat'[network_custom_tier],
      'Csat'[network_requester_type],
      'Csat'[nosat_reason],
      'Csat'[operational_unit],
      'Csat'[ou_region],
      'Csat'[queue_name],
      'Csat'[report_day],
      'Csat'[requester_uuid],
      'Csat'[site_code],
      'Csat'[text],
      'Dim_date'[date],

      RSCustomDaxFilter(
      date,
      EqualToCondition,
      [Dim_date].[date],
      DateTime
      ),

      RSCustomDaxFilter(
      @sitecode,
      EqualToCondition,
      [Csat].[site_code],
      String
      ),

      RSCustomDaxFilter(
      @operationalunit,
      EqualToCondition,
      [Csat].[operational_unit],
      String
      ),

      RSCustomDaxFilter(
      @agentemail,
      EqualToCondition,
      [Csat].[agent_email],
      String
      )
      )