Forum Discussion
Unable to combine data
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.
| 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 |
4 Replies
For the CalculateBudget query, have you looked the Advanced Editor to confirm that there is no step called AutoRemovedColumns1?
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.
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.
