Forum Discussion

BudMan512's avatar
BudMan512
Icon for Helper V rankHelper 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 ...
Need Help
BudMan512's avatar
BudMan512
Icon for Helper V rankHelper 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
Icon for Community Champion rankCommunity 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.