Forum Discussion

BudMan512's avatar
BudMan512
Helper V
5 years ago

Fetch Error, Data incongruity with ODBC connection

I am new to Power BI and am having trouble loading company sales data using an ODBC connection.

I have searched for errors and not found any. I have deleted all unnecessary columns but still am not able to load the data without the below error about Data Incongruity.

Any suggestions for resolving this issue would be much appreciated.

thanks

 

 

Need Help

4 Replies

  • negi007's avatar
    negi007
    Community Champion
    5 years ago

    BudMan512 I understand you are using ODBC DSN to connect data from powerbi. To check if you are able to connect to data source, in your powerquery window go to the first step "Source". Also try connecting to your data using ODBC in excel as well just to check if your DSN is configured correctly. 

     

     

    • BudMan512's avatar
      BudMan512
      Helper V
      5 years ago

      Not sure I explained my situation clearly.  I am able to get the sales data into Power Query with no problem and other tables can be used without a hitch.  It is when I try to Apply the data and am sending it to Power BI that I get the error.  I will look at the data in Excel though, to see if I can find an issue.

      thanks 

      • negi007's avatar
        negi007
        Community Champion
        5 years ago

        BudMan512 when you import data into powerbi, it also detect data type of each column and accordingly assign data type to it basis first 100 rows. If for example it assign data type date to a column having date but if that column is also having non-date values then error can encounterd. Try deleting the step "Changed type" where data is being converted in powerbi and see if you are able to get data in powerbi. 

    • BudMan512's avatar
      BudMan512
      Helper V
      5 years ago

      Our Admin walked me through reindexing the file and that allowed me to use the data.

      Thanks for your help.