Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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 Azuremark...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    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.