Data driven snapshot

[cg1980]

Hi team, 

We have a set of dashboards that process millon of records through SNOWFLAKE, Power bi manage the charts and KPIS properly but our customer requested a table with a datadriven snapshot, this is,  a sample of the TOP 20 / 50 records that match the report criteria.

as stated the charts and KPIS performs well but we observed that POWER BI send a FULL lookup table to obain the top n records we need and this downgrade the performace of the entire report.

Are you aware or know how we can overcome this powerbi limitation by creating a chart / table / visual that only return the "top N" records without full database lookup?

All the best ,

[cg1980]

Hi @Anonymous we tried that too, same thing ... Power bi attempt to retrieve the entire dataset and perform the top at the report level.. interesting right? 

[ghumarepratik21]

Hello,

As per my understanding that you stated, you can direclty apply visual level filter on respective charts for Top N values that you want. It will resolve your issue, you will let limited value on chart that you want and also performance will increase.

I hope this will hep you 

[Anonymous]

Hi @cg1980 ,

According to your statement, I know you connect to SNOWFLAKE to get data. It will load all data after you select the table and click OK.

Did you create a measure for your KPI visual? If so, you can filter the table in your calculation.

MEASURE = 
VAR _TOPN = TOPN(N,'Table','Table'[Value],DESC)
RETURN
CALCULATE(...,_TOPN)

For reference: TOPN

If you want to filter your table to show TopN value in Power Query, I think you can try Table.LastN() function.

For reference: Table.LastN

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.