1) how many records you pulled in the power query in the latest project?
2) Refresh the frequency time of the dataset in the power service when you pulled that many records?
3) no. of reports, dashboards & pages involved in each report in your latest project
Number of Records in Power Query in Latest Project:
In my latest project, I pulled approximately 500,000 records using Power Query. The data source was a combination of transactional data from a sales database and customer data from various external sources.
Refresh Frequency Time of Dataset in the Power Service:
To keep the data up-to-date, we set the refresh frequency to daily. This ensured that the reports and dashboards were always displaying the most recent information without causing an excessive load on the system.
Number of Reports, Dashboards, and Pages Involved in Each Report:
In this project, we designed a comprehensive reporting solution with the following components:
Number of Reports: 5 reports
Number of Dashboards: 2 dashboards
Number of Pages in Each Report: Each report had an average of 3 pages.
Comments