https://community.fabric.microsoft.com/t5/Report-Server/Pulling-large-data-from-SQL-server-and-filters/m-p/1045611#M13978 <P>Hi, I am trying to automate a process.&nbsp; The initial data is coming from sql server.&nbsp; This data is over 500k rows so the initial load is even slow. My business partner will evenually use each account for a balance sheet in a separate report (many accounts and reports). What is the best way to set this up and how should I then create a filter or report on the account while still managing the performance.&nbsp; I need flexibility to create formulas and use dax so I used an import query in sql server.&nbsp; &nbsp;</P> Thu, 23 Apr 2020 23:28:21 GMT valerial 2020-04-23T23:28:21Z https://community.fabric.microsoft.com/t5/Report-Server/Pulling-large-data-from-SQL-server-and-filters/m-p/1045611#M13978 <P>Hi, I am trying to automate a process.&nbsp; The initial data is coming from sql server.&nbsp; This data is over 500k rows so the initial load is even slow. My business partner will evenually use each account for a balance sheet in a separate report (many accounts and reports). What is the best way to set this up and how should I then create a filter or report on the account while still managing the performance.&nbsp; I need flexibility to create formulas and use dax so I used an import query in sql server.&nbsp; &nbsp;</P> Thu, 23 Apr 2020 23:28:21 GMT https://community.fabric.microsoft.com/t5/Report-Server/Pulling-large-data-from-SQL-server-and-filters/m-p/1045611#M13978 valerial 2020-04-23T23:28:21Z