Error while loading a view

[Anonymous]

Getting below error while loading a view in Power BI Desktop.

Please help.

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Divide by zero error encountered.. '.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Use the DIVIDE function instead of /.  It has an input as for what to do if there is an error. 

DIVIDE([xxxx],[yyyy],0)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[camargos88]

@Anonymous ,

It looks like you are getting an error on the view execution.... It's a division by zero.