Refresh issue

[smishra99acres]

I am geeting above error while refresh data .when i go to Removed other coumn thre is no bug showing.

[Anonymous]

Hi @smishra99acres 

The error message indicates that the query references other queries or steps, which might be causing the issue.

Here are some steps you can take to troubleshoot and resolve this issue:

The error message suggests rebuilding the data combination. This means you might need to reconfigure how your queries are combined or referenced. Ensure that each query is correctly set up and that there are no circular references.

Go through each applied step in the query editor to ensure that there are no errors in any of the steps leading up to "Removed Other Columns1". Sometimes, an error in a previous step can cause issues in subsequent steps.

If possible, try simplifying the query to isolate the issue. Remove or modify steps to see if the error persists. This can help identify the specific step causing the problem.

Please check the data source permissions, ensure that you have the necessary permissions to access the data sources.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajendraongole1]

Hi @smishra99acres - you can try the suggested approach by @nilendraFabric 

adding fews suggestions you can check the data refresh queries Individually to identify the root cause. also avoid import/direct and mixed mode 

Hope this helps.

[nilendraFabric]

Hello @smishra99acres 

Open the Query Dependencies View (in Power Query Editor under “View”).
• Ensure that all referenced queries and steps are valid and accessible.
• If a query is dependent on another, ensure that the parent query is correctly configured and does not contain errors.

If columns have been removed from the source but are still referenced in your query, update your steps to account for these changes.
• Use `Table.SelectColumns` instead of `Table.RemoveColumns` for better control over column selection.

if this helps please accept the solution and give kudos

[smishra99acres]

I have checked no error is any connection