Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
YamunaRaman
New Member

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 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.

 

 

 

2 ACCEPTED SOLUTIONS
Deku
Super User
Super User

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


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

View solution in original post

v-veshwara-msft
Community Support
Community Support

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.

View solution in original post

4 REPLIES 4
v-veshwara-msft
Community Support
Community Support

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
Community Support
Community Support

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
Community Support
Community Support

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
Super User
Super User

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


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.