Error Message while trying to refresh .pbix - Trying to change batch size in Power Query to resolve

[PBI-Curious]

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.

[Anonymous]

Hi @PBI-Curious ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed.

Best Regards,
Eyelyn Qin

[Anonymous · Accepted solution]

Hi @PBI-Curious ,

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.