Unable to combine data

[Anonymous]

I am getting this error message wehn trying to refresh a dataset which is comprised mainly of CSV files residing on a Office 365 SharePoint Document Library. There is also a reference to an AzuremarketPlace dataset and some SharePoint lists on the same Office 365 site.

There is no step "AutoRemovedColumns1" in the query CalculateBudget so I am a bit stuck as to what I should do!

The pbix file has "Ignore privacy levels...." checked under Fast Combine in Options. Is there anything else I should do?

Last refresh failed: Mon Feb 29 2016 12:23:34 GMT+0000 (GMT Standard Time) 
An error occurred while processing the data in the dataset.

Hide details

PersonalGateway_DataSourceKindLabel:
Data source error:	[Unable to combine data] Section1/CalculateBudget/AutoRemovedColumns1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
Cluster URI:	WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:	01632de3-d260-4815-8bcc-cfe882090c32
Request ID:	b0560656-6c5c-3c08-9e03-4b228113eedb
Time:	2016-02-29 12:23:34Z

[Greg_Deckler]

For the CalculateBudget query, have you looked the Advanced Editor to confirm that there is no step called AutoRemovedColumns1?

[Anonymous]

Thanks. There isn't, but I have found the issue.

There is a function called within this query (to fill some columns in) and it was doing a call to a CSV file on the SharePoint site.

I have rejigged the function to use a query within the dataset as the source (rather than the CSV file) and that now seems to be happy 🙂

Thanks for your help.

[MarkCBB]

I am gettnig a similar errror, but none of my files are in Share point, My data comes from Excel files and folders contains excel files. 

the error I get also reffers to ""AutoRemovedColumns1" but I cant figure our why. 

[MarkCBB]

I was able to sort out my challage, I found the answer in this post, Matt shared a blog post by Ken Plus.

http://community.powerbi.com/t5/Desktop/Formula-Firewall-Query-references-other-queries-so-it-may-no...