elleneal's avatar
elleneal
Frequent Visitor
9 years ago
Status:
Done

OLE DB or ODBC error DataSource.Error

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.

 

 

Data Modeling

4 Comments

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    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's avatar
    elleneal
    Frequent Visitor
    9 years ago

    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.

Completed Ideas