An error occurred while loading to the model.

[YamunaRaman]

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 while loading to the model.

• A warning message appears stating that Table1 could not be loaded.

• The following message is shown at the top:
  “There are pending changes in your queries that haven’t been applied.”

• No data is visible in the Fields pane.

[Deku · Accepted solution]

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]

Hi @YamunaRaman ,
As we haven't heard from you since last reply, following up once more regarding your query. If it has been resolved, please mark the helpful reply as the "Accepted Solution" to assist others facing similar challenges.

If you still need assistance, please let us know.
Thank you.

[v-veshwara-msft]

Hi @YamunaRaman ,
Just wanted to check if the solution provided has met your needs. If yes, Please consider marking it as "Accepted Solution" to assist others with similar queries. If further assistance is needed, please reach out.
Thank you.

[v-veshwara-msft · Accepted solution]

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.

[Deku · Accepted solution]

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