Forum Discussion

Missippy's avatar
Missippy
Icon for Helper I rankHelper I
1 year ago
Solved

Power Query/Overwrite cell question

I have a large spreadsheet with 30 power queries on it. when i run some of them,not all, some of the calculations get changed and don't work. So I read that selecting the "Overwrite cells" in the ext...
Need Help
  • Missippy's avatar
    Missippy
    1 year ago

    I didn't actualy get the problem solved. I did find an easy workaround. If some of you could actually see what its doing , I expect you could fix it. I am probably not doing a good enough job of describing it. But I am in a good spot with the form now. I appreciate the help. I am actually having a different issue that I may post when I have a chance.

  • v-hashadapu's avatar
    v-hashadapu
    1 year ago

    Hi Missippy , thank you for the update. We're glad to hear you found a workaround. Could you please share the details here and mark it as 'Accept as solution' to help others with similar issues? If you have any other questions, feel free to post them (as a new post) in the community. We're always happy to assist.

    Thank you.

MarkLaf's avatar
MarkLaf
Icon for Super User rankSuper User
1 year ago

If you mean that sometimes formulas in added columns to your table will sometimes not copy all the way down after a refresh, I've found that this can be fixed by loading into your sheets what the following article refers to as 'Reverse Linked' tables: https://www.sqlbi.com/articles/linkback-tables-in-powerpivot-for-excel-2013/

 

Basically:

  1. Load your query to the data model
  2. Insert a table from the data model using existing connections
  3. Right-click on the table, select Table > Edit DAX...
  4. In pop-up window, change Command Type to DAX
  5. Still in pop-up, in expression field, use a DAX expression that evaluates to a table. Simplest is:
    EVALUATE
    'table name'