topic Re: Data driven snapshot in Developer

Data driven snapshot

cg1980 — Tue, 22 Feb 2022 16:49:21 GMT

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 ,

Re: Data driven snapshot

Anonymous — Fri, 25 Feb 2022 09:12:32 GMT

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.

Re: Data driven snapshot

ghumarepratik21 — Fri, 25 Feb 2022 09:52:25 GMT

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

Re: Data driven snapshot

cg1980 — Mon, 28 Feb 2022 10:21:30 GMT

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?