Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I use direct query to extract ledger transactions for 6 companies from a SQL server database and produce balance sheet statements and profit and loss statements. Can anyone provide acceptable response times for such reporting? 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.
Solved! Go to Solution.
This depends on your business needs. Link below is for your reference.
Best practices for building fast and reliable reports in Power BI
This depends on your business needs. Link below is for your reference.
Best practices for building fast and reliable reports in Power BI
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
29 | |
3 | |
3 | |
2 | |
2 |