Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Index column breaks Gateway refresh

I have built a very basic model, and added Index columns to my dimension tables to allow me to replace descriptive text fields in my data table with simple integer fields. Refresh in Desktop works n...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi everyone. I think I found the problem and the solution (at least it worked for me): 

 

I'm not sure when but Microsoft updated the Power BI function Table.AddIndexColumn accepting the columnType as an optional argument at the end. When you create the Index, PowerBI uses this function with the columnType argument added. If your gateway has an unupdated version of Power BI, you will get you the error of "5 arguments were passed to function which expects between 2 and 4." because you are passing to the index function 5 arguments when it was expected to have between 2 and 4. 

 

For the solution, delete the last argument of your index formula and upload your file again. That worked for me. 

 

Good luck!

Fernando

Anonymous's avatar
Anonymous
Not applicable
5 years ago

This worked nicely for me 🙂 thank you for posting the solution