Forum Discussion

YamunaRaman's avatar
YamunaRaman
New Member
1 year ago
Solved

An error occurred while loading to the model.

This prevents the data from being imported and displayed in the report. While attempting to load data from an Excel file into Power BI Desktop, I encountered the following error: An error occurred ...
  • Deku's avatar
    1 year ago

    This means. You have changes in powerquery that are stage but need to be committed. Select transform data from the ribbon and accept any powerquery changes that are pending

  • v-veshwara-msft's avatar
    1 year ago

    Hi YamunaRaman ,
    Thanks for reaching out to Microsoft Fabric Community,

    Just checking in to see if you have resolved your issue by following the steps provided by Deku . If still unclear please consider the following:

    The error you're encountering typically occurs when there are pending changes in Power Query that have not been applied yet. To resolve this, please follow these steps:

    1. In Power BI Desktop, go to the Home tab.

    2. Click on Transform Data to open Power Query Editor.

    3. Once in Power Query, review any changes you've made. If there are pending changes, Power BI will prompt you to apply them.

    4. Click Close & Apply to commit the changes and reload the data into the model.

    This should resolve the issue and allow the data to load correctly. If the issue persists, I recommend checking the Excel file for any corruption or inconsistencies in the data structure.

    If you need further assistance, feel free to reach out again.

     

    Please consider marking the helpful reply as Accepted Solution to assist others with similar issues and a kudos would be appreciated.

    Thank you.