Revising a data source

[aashton]

I've used a sql query as my data source in my Power BI report.  I've revised the code, I've actually removed some fields, but get an error when trying to apply the changes. It is looking for the fields I deleted and won't proceed.  But, I don't want those fields, how can I tell it to apply changes and remove those fields?

[v-alq-msft]

Hi, @aashton 

Based on your error message, I'd like to suggest you apply the changes before the step where you delete those fields. For better understanding, could you show us some sample data and expected results with OneDrive for business? Do mask sensitive data before uploading. Thanks.

Best Regards

Allan

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

[Greg_Deckler]

@aashton Tough to be specific without more information but you are going to have to remove or modify steps in your query that reference those fields. Can you post your M code from Advanced Query editor and also note the fields that were removed? Then we could be more specific.