The features described in this article are only available to customers who have the necessary credentials to access to the Data Warehouse.
IN BRIEF:
Refreshing your Power BI dataset ensures your reports and dashboards display the most current information from iClassPro’s Data Warehouse. You can manually refresh your dataset in the desktop app or configure automatic refreshes in the Power BI service.
Overview
When you connect a Power BI template to your data source, Power BI imports a local copy of the data. Reports and dashboards query this local dataset rather than the live source. Because iClassPro updates your Data Warehouse nightly, you must refresh the dataset to access the latest data.
Refreshing your dataset ensures:
- You see the most up-to-date results.
- All reports connected to the Data Source reflect current information.
Accessing the Feature
Refreshing can be done either:
- In the Power BI Desktop app (manual refresh).
- Through the Power BI service (https://app.powerbi.com) for scheduled auto-refreshes.
Step-by-Step Instructions
Manually Refreshing the Dataset in Power BI Desktop
- Open the Power BI Desktop app.
- On the Home ribbon, select Refresh icon (folder with two circular arrows).
- This connects Power BI to your configured Data Source(s).
- The latest dataset(s) are imported for each report.
Scheduling an Auto-Refresh in Power BI Service
- Log in to https://app.powerbi.com.
- Select the Workspace containing the dataset you want to refresh.
- Hover over the dataset name to reveal action icons.
- Select the Refresh icon (folder with two circular arrows) next to the dataset.
- Expand Scheduled refresh.
- Switch the toggle to On.
- Configure the refresh schedule:
- Refresh frequency (e.g., daily).
- Appropriate time zone.
- Time of day to run the refresh.
- NOTE: Amazon Redshift is typically updated around 2:00 AM. To ensure accuracy, schedule your refresh after this time.
- Under Send refresh failure notifications to, enter one or more email addresses.
- If a refresh fails, Power BI sends an email with the subject line: “Refresh failed: [dataset name] has failed to refresh.”
- Select Apply to save.
Troubleshooting & FAQs
-
What if the refresh times out?
- Connection issues may cause refreshes to time out. Try scheduling the refresh twice daily for best results.
-
Why does my dashboard not show changes after refresh?
- Allow 10–15 minutes for updates to appear on the dashboard.
-
What if my dataset is too large?
- Datasets in the Power BI service have a 1 GB limit (compressed). Reduce imported data if refresh fails due to size.
-
Why was my scheduled refresh disabled?
- If refresh fails four times in a row, Power BI disables it automatically. Fix the issue and re-enable refresh.
-
What if login credentials changed or expired?
- Update credentials in Power BI using the steps in How Can I Update the Data Source in Power BI?.
-
How do I fix “Container exited unexpectedly with code 0x0000DEAD”?
- Disable the scheduled refresh and republish the dataset.
-
How do I fix “Processing Error: Type Mismatch”?
- Update Power BI Desktop to the latest version. To check your version, go to Help > About. Compare your version number with the latest version listed at Microsoft Power BI Download. If your version is older, install the latest version.
-
Where can I find more troubleshooting help?
- See Microsoft’s guide: Troubleshooting refresh scenarios.