OLE DB or ODBC error DataSource.Error

[elleneal]

Hi, 

I am trying to import data from SQL Server into the desktop. The query runs and the messages shows that rows are being uploaded. I then get the error below and no data is sent to the table in the report building page. The data does show in the query editor tables. i initially set this up as a direct query which may be why it is showing in the query editor table.

[v-haibl-msft]

@elleneal

If you are using the Import mode, is it possible to share your PBIX file through online file service like OneDrive and send the sharing link to me?

Best Regards,
Herbert

[elleneal]

Thank you for your help with this. There was an issue within the SQL Server table, it was throwing a divide by zero error, which would have stopped it from returning any results.