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.