Forum Discussion
Error Message while trying to refresh .pbix - Trying to change batch size in Power Query to resolve
Hello PBI Community Good Day!
Per the error message below, I'm trying to change the Batch size to 1000 in Power Query - Advance Editor to prevent the error message below. This is the only solution I have to resolve at the moment, please advise of any others.
Per my attempt to add in [BatchSize = 1000] I'm getting another error message....screen shots below.
Please contact me with any questions
Much appreciate your help
Thank you
Screen shot available below to show how I set it up in Advanced Editor.
Hi Anonymous ,
The right parenthesis seems to be misplaced:
It should be in the end of the Source parameter ,like:
Source=Odbc.Query("dsn=your_dsn", "select * from Customers",[BatchSize=2000])Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
The right parenthesis seems to be misplaced:
It should be in the end of the Source parameter ,like:
Source=Odbc.Query("dsn=your_dsn", "select * from Customers",[BatchSize=2000])Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.