A sales manager wants to create a dashboard that shows sales by region and product category. The data is stored in an Excel file that is updated weekly. What is the most efficient way to ensure the dashboard reflects the latest data?
Trap 1: Use Power BI Desktop to connect to the Excel file and publish a new…
This still requires manual effort and does not automate refresh.
Trap 2: Use Power Query to merge data from the Excel file and create a…
Power Query transforms data but does not schedule refreshes in the service.
Trap 3: Upload the Excel file to the Power BI service each week
Manual uploads are inefficient and not the best practice for regular updates.
- A
Publish the report from Power BI Desktop and schedule a daily data refresh in Power BI service
Scheduled refresh automates data updates without manual intervention.
- B
Use Power BI Desktop to connect to the Excel file and publish a new report weekly
Why wrong: This still requires manual effort and does not automate refresh.
- C
Use Power Query to merge data from the Excel file and create a composite model
Why wrong: Power Query transforms data but does not schedule refreshes in the service.
- D
Upload the Excel file to the Power BI service each week
Why wrong: Manual uploads are inefficient and not the best practice for regular updates.