Forum Discussion
Helper IDAX query with SUMMARIZECOLUMNS - Optimization
Hi everyone,
I’m facing a critical performance issue in Power BI when running an advanced DAX query used by a paginated report. The query operates over a large fact table (~131 million rows) and produces a memory-related failure:
Error message:
“Resource Governance: This query uses more memory than the configured limit…”
The code as bellow is the third version of my optimazation , i need your help to see if i can do better
EVALUATE
//------------------------------------
// DATASET A (View A)
//------------------------------------
VAR A_Base =
CALCULATETABLE (
SUMMARIZECOLUMNS (
'DimDate'[DateKey],
'DimDate'[Period],
'DimAttribute1'[CategoryA],
'DimAttribute2'[CategoryB],
'DimAttribute3'[CategoryC],
'DimEntityA'[EntityKey],
'DimEntityB'[ExternalKey],
'DimLocationA'[LocationCode],
'DimLocationA'[DirectionCode],
'DimGroupA'[GroupLabel],
'DimEntityA'[EntityName],
'DimAttribute1'[City],
'DimAttribute1'[PostalCode],
'DimStatus'[StatusLabel],
'DimHierarchyA'[HierarchyLevel],
'DimEntityA'[EntityType],
'DimEntityA'[EntitySubtype],
"MetricA_Main", [MetricA_Main]
),
'DimDate'[Period] = @pPeriod,
'DimAttribute4'[CategoryA] = @pCategory,
DimTypeOrder[OrderCode] IN { 11, 32}
)
VAR A_WithMetrics =
ADDCOLUMNS (
A_Base,
"MetricA_Flag1", [MetricA_Flag1],
"MetricA_Flag2", [MetricA_Flag2],
"MetricA_Flag3", [MetricA_Flag3],
"MetricA_Flag4", [MetricA_Flag4],
"MetricA_FlagAM", [MetricA_FlagAM],
"MetricA_FlagPM", [MetricA_FlagPM],
"MetricA_Status", [MetricA_Status],
"MetricA_Value1", [MetricA_Value1],
"MetricA_Value2", [MetricA_Value2],
"MetricA_Value3", [MetricA_Value3],
"MetricA_Value4", [MetricA_Value4]
)
VAR A_Filtered =
FILTER ( A_WithMetrics, NOT ISBLANK ( [MetricA_Main] ) )
VAR A_View =
SELECTCOLUMNS (
A_Filtered,
"Date", FORMAT ( 'DimDate'[DateKey], "DD-MM-YYYY" ),
"Period", 'DimDate'[Period],
"CategoryA", 'DimAttribute1'[CategoryA] & "",
"CategoryB", 'DimAttribute2'[CategoryB],
"CategoryC", 'DimAttribute3'[CategoryC],
"EntityKey", 'DimEntityA'[EntityKey] & "",
"ExternalKey", 'DimEntityB'[ExternalKey] & "",
"Location", 'DimLocationA'[LocationCode] & "",
"Direction", 'DimLocationA'[DirectionCode] & "",
"GroupLabel", 'DimGroupA'[GroupLabel] & "",
"EntityName", 'DimEntityA'[EntityName] & "",
"City", 'DimAttribute1'[City] & "",
"PostalCode", 'DimAttribute1'[PostalCode] & "",
"StatusLabel", 'DimStatus'[StatusLabel],
"Hierarchy", 'DimHierarchyA'[HierarchyLevel] & "",
"EntityType", 'DimEntityA'[EntityType] & "",
"EntitySubtype", 'DimEntityA'[EntitySubtype] & "",
"Metric_Value1", [MetricA_Value1],
"Metric_Value2", [MetricA_Value2],
"Metric_Value3", [MetricA_Value3],
"Metric_Value4", [MetricA_Value4],
"Flag1", [MetricA_Flag1],
"Flag2", [MetricA_Flag2],
"Flag3", [MetricA_Flag3],
"Flag4", [MetricA_Flag4],
"Flag_AM", [MetricA_FlagAM],
"Flag_PM", [MetricA_FlagPM],
"StatusFlag", [MetricA_Status]
)
//------------------------------------
// DATASET B (View B)
//------------------------------------
VAR B_Base =
CALCULATETABLE (
SUMMARIZECOLUMNS (
'DimDate'[DateKey],
'DimDate'[Period],
'DimAttribute4'[CategoryA],
'DimAttribute2'[CategoryB],
'DimAttribute3'[CategoryC],
'DimEntityC'[EntityKey],
'DimEntityD'[ExternalKey],
'DimLocationB'[LocationCode],
'DimLocationB'[DirectionCode],
'DimGroupB'[GroupLabel],
'DimEntityC'[EntityName],
'DimAttribute4'[City],
'DimAttribute4'[PostalCode],
'DimStatus'[StatusLabel],
'DimHierarchyB'[HierarchyLevel],
'DimEntityC'[EntityType],
'DimEntityC'[EntitySubtype],
"MetricB_Main", [MetricB_Main],
"MetricB_Alt", [MetricB_Alt]
),
'DimDate'[Period] = @pPeriod,
'DimAttribute4'[CategoryA] = @pCategory
)
VAR B_WithMetrics =
ADDCOLUMNS (
B_Base,
"MetricB_Flag1", [MetricB_Flag1],
"MetricB_Flag2", [MetricB_Flag2],
"MetricB_Flag3", [MetricB_Flag3],
"MetricB_Flag4", [MetricB_Flag4],
"MetricB_FlagAM", [MetricB_FlagAM],
"MetricB_FlagPM", [MetricB_FlagPM],
"MetricB_Status", [MetricB_Status],
"MetricB_Alt1", [MetricB_Alt1],
"MetricB_Alt2", [MetricB_Alt2]
)
VAR B_Filtered =
FILTER (
B_WithMetrics,
NOT ( ISBLANK ( [MetricB_Main] ) && ISBLANK ( [MetricB_Alt] ) )
)
VAR B_View =
SELECTCOLUMNS (
B_Filtered,
"Date", FORMAT ( 'DimDate'[DateKey], "DD-MM-YYYY" ),
"Period", 'DimDate'[Period],
"CategoryA", 'DimAttribute4'[CategoryA] & "",
"CategoryB", 'DimAttribute2'[CategoryB],
"CategoryC", 'DimAttribute3'[CategoryC],
"EntityKey", 'DimEntityC'[EntityKey] & "",
"ExternalKey", 'DimEntityD'[ExternalKey] & "",
"Location", 'DimLocationB'[LocationCode] & "",
"Direction", 'DimLocationB'[DirectionCode] & "",
"GroupLabel", 'DimGroupB'[GroupLabel] & "",
"EntityName", 'DimEntityC'[EntityName] & "",
"City", 'DimAttribute4'[City] & "",
"PostalCode", 'DimAttribute4'[PostalCode] & "",
"StatusLabel", 'DimStatus'[StatusLabel],
"Hierarchy", 'DimHierarchyB'[HierarchyLevel] & "",
"EntityType", 'DimEntityC'[EntityType] & "",
"EntitySubtype", 'DimEntityC'[EntitySubtype] & "",
"MetricB_Main", [MetricB_Main],
"MetricB_Alt", [MetricB_Alt],
"MetricB_Alt1", [MetricB_Alt1],
"MetricB_Alt2", [MetricB_Alt2],
"Flag1", [MetricB_Flag1],
"Flag2", [MetricB_Flag2],
"Flag3", [MetricB_Flag3],
"Flag4", [MetricB_Flag4],
"Flag_AM", [MetricB_FlagAM],
"Flag_PM", [MetricB_FlagPM],
"StatusFlag", [MetricB_Status]
)
//------------------------------------
// FULL OUTER JOIN
//------------------------------------
VAR JoinA =
SELECTCOLUMNS (
NATURALLEFTOUTERJOIN ( A_View, B_View ),
"Date", [Date],
"Period", [Period],
"CategoryA", [CategoryA],
"CategoryB", [CategoryB],
"CategoryC", [CategoryC],
"EntityKey", [EntityKey],
"ExternalKey", [ExternalKey],
"Location", [Location],
"Direction", [Direction],
"GroupLabel", [GroupLabel],
"EntityName", [EntityName],
"City", [City],
"PostalCode", [PostalCode],
"StatusLabel", [StatusLabel],
"Hierarchy", [Hierarchy],
"EntityType", [EntityType],
"EntitySubtype", [EntitySubtype],
"MetricA_Main", [MetricA_Main],
"MetricA_Value1", [MetricA_Value1],
"MetricA_Value2", [MetricA_Value2],
"MetricA_Value3", [MetricA_Value3],
"MetricA_Value4", [MetricA_Value4],
"MetricB_Main", [MetricB_Main],
"MetricB_Alt", [MetricB_Alt],
"MetricB_Alt1", [MetricB_Alt1],
"MetricB_Alt2", [MetricB_Alt2],
"Flag1", [Flag1],
"Flag2", [Flag2],
"Flag3", [Flag3],
"Flag4", [Flag4],
"Flag_AM", [Flag_AM],
"Flag_PM", [Flag_PM],
"StatusFlag", [StatusFlag]
)
VAR JoinB =
SELECTCOLUMNS (
NATURALLEFTOUTERJOIN ( B_View, A_View ),
"Date", [Date],
"Period", [Period],
"CategoryA", [CategoryA],
"CategoryB", [CategoryB],
"CategoryC", [CategoryC],
"EntityKey", [EntityKey],
"ExternalKey", [ExternalKey],
"Location", [Location],
"Direction", [Direction],
"GroupLabel", [GroupLabel],
"EntityName", [EntityName],
"City", [City],
"PostalCode", [PostalCode],
"StatusLabel", [StatusLabel],
"Hierarchy", [Hierarchy],
"EntityType", [EntityType],
"EntitySubtype", [EntitySubtype],
"MetricA_Main", [MetricA_Main],
"MetricA_Value1", [MetricA_Value1],
"MetricA_Value2", [MetricA_Value2],
"MetricA_Value3", [MetricA_Value3],
"MetricA_Value4", [MetricA_Value4],
"MetricB_Main", [MetricB_Main],
"MetricB_Alt", [MetricB_Alt],
"MetricB_Alt1", [MetricB_Alt1],
"MetricB_Alt2", [MetricB_Alt2],
"Flag1", [Flag1],
"Flag2", [Flag2],
"Flag3", [Flag3],
"Flag4", [Flag4],
"Flag_AM", [Flag_AM],
"Flag_PM", [Flag_PM],
"StatusFlag", [StatusFlag]
)
RETURN
DISTINCT ( UNION ( JoinA, JoinB ) )
Thanks for help !
Hi Mr_Robot0092 ,
try loading data using dataflows gen 2 and load it in semantic model and use it for paginated report.
below thread may help:
Please give kudos or mark it as solution once confirmed.
Thanks and Regards,
Praful
Hi Mr_Robot0092,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to amitchandak, for his inputs on this thread.
Thanks for confirming and for testing that. Just to clarify the syntax issue you are seeing with FILTER() inside SUMMARIZECOLUMNS is expected. The function doesn’t allow filters in that position, which is why it errors out.
However, even if the syntax was adjusted, it unfortunately wouldn’t resolve the original memory issue. The error you are facing is caused by the size of the intermediate tables this query generates, combined with the full outer join in DAX. That is what triggers the Resource Governance limit.
The best approach here is still to move the heavy transformations (joins, merging, grouping, filtering) out of DAX and into Power Query / SQL / Warehouse and only return the required dataset to the report. That is what will avoid the memory limitation completely.Refer this link: https://learn.microsoft.com/en-us/dax/summarizecolumns-function-dax
Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.
Thank you for using the Microsoft Fabric Community Forum.
13 Replies
- amitchandak
Super User
Mr_Robot0092 , First of all, I would suggest not doing this using DAX. Do it in Power Query instead—you have Group By, Merge, and Append queries available.
Second, I would say don’t even rely on Power Query for this. Prefer loading the data into a Lakehouse or Warehouse in Fabric, and then use SQL or PySpark for the transformation.
Few Changes you can doAvoid calculate table
VAR A_Base = SUMMARIZECOLUMNS( 'DimDate'[DateKey], 'DimDate'[Period], ... "MetricA_Main", [MetricA_Main], FILTER( DimTypeOrder, DimTypeOrder[OrderCode] IN { 11, 32} ), 'DimDate'[Period], @pPeriod, 'DimAttribute4'[CategoryA], @pCategory )Avoid format and append
FORMAT('DimDate'[DateKey], "DD-MM-YYYY")
'DimAttribute1'[CategoryA] & ""
Mr_Robot0092Thanks for replying and suggestions.
For the changes , i have an error when i used the filter inside SUMMARIZECOLUMNS- amitchandak
Mr_Robot0092 , Please share the code SUMMARIZECOLUMNS and error
v-kpoloju-msftCommunity Support
Hi Mr_Robot0092,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to amitchandak, for his inputs on this thread.
Thanks for confirming and for testing that. Just to clarify the syntax issue you are seeing with FILTER() inside SUMMARIZECOLUMNS is expected. The function doesn’t allow filters in that position, which is why it errors out.
However, even if the syntax was adjusted, it unfortunately wouldn’t resolve the original memory issue. The error you are facing is caused by the size of the intermediate tables this query generates, combined with the full outer join in DAX. That is what triggers the Resource Governance limit.
The best approach here is still to move the heavy transformations (joins, merging, grouping, filtering) out of DAX and into Power Query / SQL / Warehouse and only return the required dataset to the report. That is what will avoid the memory limitation completely.Refer this link: https://learn.microsoft.com/en-us/dax/summarizecolumns-function-dax
Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.
Thank you for using the Microsoft Fabric Community Forum.
- v-kpoloju-msft
Hi Mr_Robot0092,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.
- v-kpoloju-msft
Hi Mr_Robot0092,
Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.Thank you.
- Mr_Robot0092
Hello,
I am asking this question again because my initial post did not receive an answer, and I urgently need help to resolve this issue.
I have a DAX query running inside a paginated report. The purpose of the report is to generate an extraction for the client.
When I deploy the report to the Power BI Service and execute it, I receive the following error:Unable to render paginated reportThere was an error communicating with Analysis Services. Resource Governance: This query uses more memory than the configured limit. The query — or calculations referenced by it — might be too memory-intensive to run. Either simplify the query or its calculations, or if using Power BI Premium, you may reach out to your capacity administrator to see if they can increase the per-query memory limit. More details: consumed memory MB, memory limit MB. See https://go.microsoft.com/fwlink/?linkid=2159752 to learn more.
What I have tried so far (issue still persists):
Optimized the DAX query
Created a calculated table in Power Query
Split the logic into two calculated tables in Power Query
As bellow my last version of the query :
EVALUATE //------------------------------------ // DATASET A (View A) //------------------------------------ VAR A_Base = CALCULATETABLE ( SUMMARIZECOLUMNS ( 'DimDate'[DateKey], 'DimDate'[Period], 'DimAttribute1'[CategoryA], 'DimAttribute2'[CategoryB], 'DimAttribute3'[CategoryC], 'DimEntityA'[EntityKey], 'DimEntityB'[ExternalKey], 'DimLocationA'[LocationCode], 'DimLocationA'[DirectionCode], 'DimGroupA'[GroupLabel], 'DimEntityA'[EntityName], 'DimAttribute1'[City], 'DimAttribute1'[PostalCode], 'DimStatus'[StatusLabel], 'DimHierarchyA'[HierarchyLevel], 'DimEntityA'[EntityType], 'DimEntityA'[EntitySubtype], "MetricA_Main", [MetricA_Main] ), 'DimDate'[Period] = "2024-09", 'DimAttribute4'[CategoryA] = "All", DimTypeOrder[OrderCode] IN { 11, 32} ) VAR A_WithMetrics = ADDCOLUMNS ( A_Base, "MetricA_Flag1", [MetricA_Flag1], "MetricA_Flag2", [MetricA_Flag2], "MetricA_Flag3", [MetricA_Flag3], "MetricA_Flag4", [MetricA_Flag4], "MetricA_FlagAM", [MetricA_FlagAM], "MetricA_FlagPM", [MetricA_FlagPM], "MetricA_Status", [MetricA_Status], "MetricA_Value1", [MetricA_Value1], "MetricA_Value2", [MetricA_Value2], "MetricA_Value3", [MetricA_Value3], "MetricA_Value4", [MetricA_Value4] ) VAR A_Filtered = FILTER ( A_WithMetrics, NOT ISBLANK ( [MetricA_Main] ) ) VAR A_View = SELECTCOLUMNS ( A_Filtered, "Date", FORMAT ( 'DimDate'[DateKey], "DD-MM-YYYY" ), "Period", 'DimDate'[Period], "CategoryA", 'DimAttribute1'[CategoryA] & "", "CategoryB", 'DimAttribute2'[CategoryB], "CategoryC", 'DimAttribute3'[CategoryC], "EntityKey", 'DimEntityA'[EntityKey] & "", "ExternalKey", 'DimEntityB'[ExternalKey] & "", "Location", 'DimLocationA'[LocationCode] & "", "Direction", 'DimLocationA'[DirectionCode] & "", "GroupLabel", 'DimGroupA'[GroupLabel] & "", "EntityName", 'DimEntityA'[EntityName] & "", "City", 'DimAttribute1'[City] & "", "PostalCode", 'DimAttribute1'[PostalCode] & "", "StatusLabel", 'DimStatus'[StatusLabel], "Hierarchy", 'DimHierarchyA'[HierarchyLevel] & "", "EntityType", 'DimEntityA'[EntityType] & "", "EntitySubtype", 'DimEntityA'[EntitySubtype] & "", "Metric_Value1", [MetricA_Value1], "Metric_Value2", [MetricA_Value2], "Metric_Value3", [MetricA_Value3], "Metric_Value4", [MetricA_Value4], "Flag1", [MetricA_Flag1], "Flag2", [MetricA_Flag2], "Flag3", [MetricA_Flag3], "Flag4", [MetricA_Flag4], "Flag_AM", [MetricA_FlagAM], "Flag_PM", [MetricA_FlagPM], "StatusFlag", [MetricA_Status] ) //------------------------------------ // DATASET B (View B) //------------------------------------ VAR B_Base = CALCULATETABLE ( SUMMARIZECOLUMNS ( 'DimDate'[DateKey], 'DimDate'[Period], 'DimAttribute4'[CategoryA], 'DimAttribute2'[CategoryB], 'DimAttribute3'[CategoryC], 'DimEntityC'[EntityKey], 'DimEntityD'[ExternalKey], 'DimLocationB'[LocationCode], 'DimLocationB'[DirectionCode], 'DimGroupB'[GroupLabel], 'DimEntityC'[EntityName], 'DimAttribute4'[City], 'DimAttribute4'[PostalCode], 'DimStatus'[StatusLabel], 'DimHierarchyB'[HierarchyLevel], 'DimEntityC'[EntityType], 'DimEntityC'[EntitySubtype], "MetricB_Main", [MetricB_Main], "MetricB_Alt", [MetricB_Alt] ), 'DimDate'[Period] = "2024-09",, 'DimAttribute4'[CategoryA] = "All" ) VAR B_WithMetrics = ADDCOLUMNS ( B_Base, "MetricB_Flag1", [MetricB_Flag1], "MetricB_Flag2", [MetricB_Flag2], "MetricB_Flag3", [MetricB_Flag3], "MetricB_Flag4", [MetricB_Flag4], "MetricB_FlagAM", [MetricB_FlagAM], "MetricB_FlagPM", [MetricB_FlagPM], "MetricB_Status", [MetricB_Status], "MetricB_Alt1", [MetricB_Alt1], "MetricB_Alt2", [MetricB_Alt2] ) VAR B_Filtered = FILTER ( B_WithMetrics, NOT ( ISBLANK ( [MetricB_Main] ) && ISBLANK ( [MetricB_Alt] ) ) ) VAR B_View = SELECTCOLUMNS ( B_Filtered, "Date", FORMAT ( 'DimDate'[DateKey], "DD-MM-YYYY" ), "Period", 'DimDate'[Period], "CategoryA", 'DimAttribute4'[CategoryA] & "", "CategoryB", 'DimAttribute2'[CategoryB], "CategoryC", 'DimAttribute3'[CategoryC], "EntityKey", 'DimEntityC'[EntityKey] & "", "ExternalKey", 'DimEntityD'[ExternalKey] & "", "Location", 'DimLocationB'[LocationCode] & "", "Direction", 'DimLocationB'[DirectionCode] & "", "GroupLabel", 'DimGroupB'[GroupLabel] & "", "EntityName", 'DimEntityC'[EntityName] & "", "City", 'DimAttribute4'[City] & "", "PostalCode", 'DimAttribute4'[PostalCode] & "", "StatusLabel", 'DimStatus'[StatusLabel], "Hierarchy", 'DimHierarchyB'[HierarchyLevel] & "", "EntityType", 'DimEntityC'[EntityType] & "", "EntitySubtype", 'DimEntityC'[EntitySubtype] & "", "MetricB_Main", [MetricB_Main], "MetricB_Alt", [MetricB_Alt], "MetricB_Alt1", [MetricB_Alt1], "MetricB_Alt2", [MetricB_Alt2], "Flag1", [MetricB_Flag1], "Flag2", [MetricB_Flag2], "Flag3", [MetricB_Flag3], "Flag4", [MetricB_Flag4], "Flag_AM", [MetricB_FlagAM], "Flag_PM", [MetricB_FlagPM], "StatusFlag", [MetricB_Status] ) //------------------------------------ // FULL OUTER JOIN //------------------------------------ VAR JoinA = SELECTCOLUMNS ( NATURALLEFTOUTERJOIN ( A_View, B_View ), "Date", [Date], "Period", [Period], "CategoryA", [CategoryA], "CategoryB", [CategoryB], "CategoryC", [CategoryC], "EntityKey", [EntityKey], "ExternalKey", [ExternalKey], "Location", [Location], "Direction", [Direction], "GroupLabel", [GroupLabel], "EntityName", [EntityName], "City", [City], "PostalCode", [PostalCode], "StatusLabel", [StatusLabel], "Hierarchy", [Hierarchy], "EntityType", [EntityType], "EntitySubtype", [EntitySubtype], "MetricA_Main", [MetricA_Main], "MetricA_Value1", [MetricA_Value1], "MetricA_Value2", [MetricA_Value2], "MetricA_Value3", [MetricA_Value3], "MetricA_Value4", [MetricA_Value4], "MetricB_Main", [MetricB_Main], "MetricB_Alt", [MetricB_Alt], "MetricB_Alt1", [MetricB_Alt1], "MetricB_Alt2", [MetricB_Alt2], "Flag1", [Flag1], "Flag2", [Flag2], "Flag3", [Flag3], "Flag4", [Flag4], "Flag_AM", [Flag_AM], "Flag_PM", [Flag_PM], "StatusFlag", [StatusFlag] ) VAR JoinB = SELECTCOLUMNS ( NATURALLEFTOUTERJOIN ( B_View, A_View ), "Date", [Date], "Period", [Period], "CategoryA", [CategoryA], "CategoryB", [CategoryB], "CategoryC", [CategoryC], "EntityKey", [EntityKey], "ExternalKey", [ExternalKey], "Location", [Location], "Direction", [Direction], "GroupLabel", [GroupLabel], "EntityName", [EntityName], "City", [City], "PostalCode", [PostalCode], "StatusLabel", [StatusLabel], "Hierarchy", [Hierarchy], "EntityType", [EntityType], "EntitySubtype", [EntitySubtype], "MetricA_Main", [MetricA_Main], "MetricA_Value1", [MetricA_Value1], "MetricA_Value2", [MetricA_Value2], "MetricA_Value3", [MetricA_Value3], "MetricA_Value4", [MetricA_Value4], "MetricB_Main", [MetricB_Main], "MetricB_Alt", [MetricB_Alt], "MetricB_Alt1", [MetricB_Alt1], "MetricB_Alt2", [MetricB_Alt2], "Flag1", [Flag1], "Flag2", [Flag2], "Flag3", [Flag3], "Flag4", [Flag4], "Flag_AM", [Flag_AM], "Flag_PM", [Flag_PM], "StatusFlag", [StatusFlag] ) RETURN DISTINCT ( UNION ( JoinA, JoinB ) )Any help, best practices, or alternative approaches for optimizing this type of DAX query over a large fact table would be greatly appreciated.
- GeraldGEmerick
Memorable Member
Mr_Robot0092 Are you able to provide sample data so that we can see what this code generates and what might be done to accomplish the same result but more efficiently?
- Mr_Robot0092
GeraldGEmerick Thanks for your answer. Unfortunately, it’s difficult for me to share sample data because the dataset contains sensitive client information and can’t be publicly exposed.
However, I can anonymize columns, provide the structure of the tables, and describe the expected output if that helps. Let me know what format would be most useful.
- Praful_Potphode
Hi Mr_Robot0092 ,
try loading data using dataflows gen 2 and load it in semantic model and use it for paginated report.
below thread may help:
Please give kudos or mark it as solution once confirmed.
Thanks and Regards,
Praful
