Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
84
Views
Topic starter
= Excel.CurrentWorkbook(File.Contents("C:UsersPractice Filespq_3.02.xlsx"))
When I enter my path, I get an Expression Error: 1 arguments were passed to a function which expects 0.
Expression.Error: 1 arguments were passed to a function which expects 0.
Details:
Pattern=
Arguments=List
Where is this error coming from?
Thank you.
Robert
Posted : 23/06/2018 8:02 pm
Hi Robert,
In 3.02 you are adviced to use :
Excel.Workbook(File.Contents ("INSERT YOUR FILE PATH HERE"))
not what's written in your message:
Excel.CurrentWorkbook(File.Contents("C:UsersPractice Filespq_3.02.xlsx"))
Try without Current, the functions are not the same.
As described here: https://msdn.microsoft.com/en-us/query-bi/m/excel-currentworkbook
Excel.CurrentWorkbook() as table does not have any arguments and you are passing one to this function.
Posted : 24/06/2018 6:42 am
