Forum Discussion
Helper VFetch Error, Data incongruity with ODBC connection
Community ChampionBudMan512 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.
Helper VNot 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
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.