Paginated Reports

[ahmedshalabyy12]

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 

[burakkaragoz]

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.

[ahmedshalabyy12]

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
)
)