https://community.fabric.microsoft.com/t5/Developer/Performance-benchmark-financial-statement-reporting/m-p/368180#M10978 <P>I use <U>direct query</U> to extract ledger transactions for 6 companies from a SQL server database and produce balance sheet statements and profit and loss statements. <STRONG>Can anyone provide acceptable response times for such reporting?</STRONG> I have three slicers: 1)select value in dollars, thousands, etc. 2) select by company, and 3) select by date in a hierarchical way (year, quarter, month). Thank you in advance. It is estimated that each fiscal year will contain about 40,000 records.&nbsp;</P> Fri, 02 Mar 2018 00:30:58 GMT elikater 2018-03-02T00:30:58Z https://community.fabric.microsoft.com/t5/Developer/Performance-benchmark-financial-statement-reporting/m-p/368180#M10978 <P>I use <U>direct query</U> to extract ledger transactions for 6 companies from a SQL server database and produce balance sheet statements and profit and loss statements. <STRONG>Can anyone provide acceptable response times for such reporting?</STRONG> I have three slicers: 1)select value in dollars, thousands, etc. 2) select by company, and 3) select by date in a hierarchical way (year, quarter, month). Thank you in advance. It is estimated that each fiscal year will contain about 40,000 records.&nbsp;</P> Fri, 02 Mar 2018 00:30:58 GMT https://community.fabric.microsoft.com/t5/Developer/Performance-benchmark-financial-statement-reporting/m-p/368180#M10978 elikater 2018-03-02T00:30:58Z https://community.fabric.microsoft.com/t5/Developer/Performance-benchmark-financial-statement-reporting/m-p/369404#M11015 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/56670">@elikater</a>,</P> <P>&nbsp;</P> <P>This depends on your business needs. Link below is for your reference.</P> <P><A class="selected" tabindex="0" href="https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance" data-showme="true" data-text="best practices for building fast and reliable reports in power bi " target="_blank">Best practices for building fast and reliable reports in Power BI</A></P> Mon, 05 Mar 2018 02:38:39 GMT https://community.fabric.microsoft.com/t5/Developer/Performance-benchmark-financial-statement-reporting/m-p/369404#M11015 v-chuncz-msft 2018-03-05T02:38:39Z