Forum Discussion

aashton's avatar
aashton
Helper V
5 years ago

Revising a data source

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?

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    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.

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    5 years ago

    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.