The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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
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:
In Power BI Desktop, go to the Home tab.
Click on Transform Data to open Power Query Editor.
Once in Power Query, review any changes you've made. If there are pending changes, Power BI will prompt you to apply them.
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.
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.
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.
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:
In Power BI Desktop, go to the Home tab.
Click on Transform Data to open Power Query Editor.
Once in Power Query, review any changes you've made. If there are pending changes, Power BI will prompt you to apply them.
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.
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
User | Count |
---|---|
78 | |
77 | |
38 | |
31 | |
28 |
User | Count |
---|---|
106 | |
98 | |
55 | |
49 | |
47 |