Power BI Schema Refresh - Required for Power BI Reports after Business Central 28.0 Update

Purpose: The instructions below detail the steps to refresh a Power BI Schema. A Schema Refresh is required when the dataset changes by either removing a field or renaming it. This is common with product version updates, such as Business Centrals 28.0 release. You should proactively follow the steps below to update any dependent Power BI data models after Business Central has updated to version 28.0. Failure to do so will result in failed Power BI data model refreshes until the steps below are completed.

Step-by-Step Procedures

Step 1: Identify the Failed Dataset

1. In Power BI Service, navigate to the workspace
2. Locate the dataset (aka Semantic Model) with refresh failures
3. View the error message (typically references 404, Entity not found, or OData metadata issues)

---

Step 2: Download the PBIX File

1. In the workspace, select More options (⋯) next to the report
2. Choose Download this file (.pbix)
3. Save the file locally

---

Step 3: Open the Report in Power BI Desktop

1. Open Power BI Desktop
2. Open the downloaded .pbix
3. Allow credentials to authenticate if prompted

---

Step 4: Refresh the Data Source Schema

1. In Power BI Desktop, select the Transform data dropdown
2. Select Refresh Schema and Data

---

Step 5: Validate the Model

Before publishing:

• Confirm all tables load successfully
• Check Model view for broken relationships
• Validate key visuals

---

Step 6: Republish to Power BI Service

1. Select Publish in Power BI Desktop
2. Choose the original workspace
3. Confirm overwrite when prompted

---

Step 7: Reconfigure Dataset Settings (If Needed)

After republishing:

• Verify scheduled refresh
• Confirm credentials are valid

For questions or assistance, please open a support ticket with Cargas.