Forum Discussion
#REF error after Power Query refresh
A power query + data model + power pivot solution can also be considered by creating relationships from supplier table and product table as dim tables (lookup tables) to the parameter/calc table (fact table) then, display the results into a power pivot especially if supplier/product calculation is high volume would be most efficient.
cannot be done that way, please provide a sample file since power query is a complicated function to explain.
cheers
Thank you for looking into this!
Attached a simplified sample workbook. Strangely enough, in the sample workbook everything works, while in my real file, which does basically the same, I get the #REF error.
Still, it would be great if you could look into the sample workbook and advise on best practice.
So var is the price * Qty
Question: I am assuming the PQ result is the fact table? How is that going to work when you switch the parameters from B to A, do a refresh and then when coming back to B and do a refresh the values you entered for the A supplier will disappear.
- Yes, that's not a problem. The user chooses a supplier, then fills in values, then copies the results. So it's okay for the values to disappear once the calculation has been made.
To make things even stranger, the exact same file that gave #REF errors yesterday, works fine now...
