Share via

Excel and PowerQuery not loading Data Sources

Anonymous
2024-04-11T17:13:23+00:00

Excel 365 64 bit - I have imported a file From Text/CSV - Load To - Only Create Connection - Add this data to the Data Model. When I hover over the file in the Queries & Connections pane the Load status states: Loaded to Data Model. The Data Sources is still Loading - not sure why this is happening? I am able to see everything in the Manage Data Model. The file imported is a Microsoft Excel Comma Separated Values File (.csv)

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-04-11T17:49:02+00:00

    Hi, thank you for reaching out. My name is Deeksha and I'm a Microsoft user like yourself and I will try to help you as best as I can today.

    Check the Data Model: Go to the “Data” tab. Click on “Manage Data Model” to ensure that your data has been imported correctly.

    Refresh the Data Model: In the “Data” tab, click on “Refresh All” to update the Data Model.

    Review the Queries & Connection: Go to the “Queries & Connections” pane. Right-click on the query in question and select “Edit” to open the Power Query Editor and check if there are any errors or issues.

    Check for Excel Updates: Ensure that you have the latest version of Excel as updates can fix bugs and improve performance.

    Restart Excel: Close and reopen Excel to refresh the program's state and clear any temporary glitches.

    Monitor the Task Manager: Open the Task Manager to see if Excel is using an unusual amount of CPU or memory, indicating a possible hang in the process.

    Reduce Data Size: If the data set is very large, consider filtering it or removing unnecessary columns in the Power Query Editor before loading to the Data Model.

    Check Your Network Connection: If your data is from an external source, ensure that your internet connection is stable.

    Excel Options: Go to “File” > “Options” > “Data”. Check the options related to data loading and ensure that the background refresh is enabled.

    Advanced Data Model Options: In “File” > “Options” > “Advanced”. Scroll down to the “Data” section and adjust settings for the Data Model if needed.

    Check for External Links or Queries: Sometimes the data model may try to update or load related data from other sources. Ensure all connections are functioning properly.

    Use Excel Support and Troubleshooting: Access Excel's built-in help.

    Consider Excel Limits: There are limits to the size of the Data Model depending on the Excel version and if you’re nearing those limits, consider breaking down your data.

    Re-import the CSV File if Necessary: If the above doesn't work, you may need to remove the current connection and re-import the CSV file.

    Try these steps and hopefully, it resolves your issue. In case you need further help or assistance, please let us know. You can also contact Microsoft Support if the problem persists.

    Best regards Deeksha

    0 comments